Join or Look up involving three tables

Hi all,

i have three tables A, B and C.

Table A

Column 1 Column 2 Column 3 001 abc def 002 ghi jkl 003 mno pqr

Table B

Column 4 Column 1 1051 001 1052 002

Table C

Column 5 Column 4 100001 1041 100002 1051

Output :

Column 1 Column 2 Column 3 001 abc def

I want to apply a SQL query like this

Select * from Table A where column1 in (select column4 from TableB join TableC on TableB.Column4=TableC.Column4)

( i think it's easy to explain in SQL query)

Trying to get the records based on Column 1 that exists in Table B depends on column 4 values in Table C. Provided sample output data.

So How can we implement this in Designer ? Join or Look up?