I have 3 tables, linked using keys:
table1 link to table2
table1 link to table3
I need to select sths out of table 2 and 3, linking by 1.
Some content in 3 may not available, I want to get null intead.
Any suggestion? How to write the sql? using join?, I tried but failed.