I have a problem about left join and sub submit

[surfchen]

select * from table1 where t1_c1 in (select t1_c1 from table2 where t2_c=5) and t1_c2 in (select t1_c1 from table3 where t3_c=5);

how to convert to left join version>?????
user left join~~

thanks

[nemonoman]

SELECT *
FROM table1
LEFT JOIN table2
ON table1.tc1_c1=table2.tc1_c1
LEFT JOIN table3
ON table1.t1_c2 =table2.t1_c1
WHERE t2_c=5
AND t3_c=5