I need to join the three tables.
TABLE 1 is the main table
It want to join to table1 to tablet2 where table1_ID1 = table2_ID
and to join table1 to table3 where table1_ID1 = table3_ID
Only records with values in all three tables should be joined.
I am using DB2
How can this be done?