This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
table1 to table2 is one-to-many
table2 to table3 is one-to-one
Looks like you want records from table 3 when you don't have any records in table 2 (no children).
This would only be possible when you have some sort of direct relationship between table1 and table 3 (probably one-to-many).
Cheers, Joy [SCJP 1.4, SCBCD 5.0]
get high on alcohol, algorithm or both