I want to join 3 tables. All three tables contain an ID field. Here's an example of the code that I used (but doesn't do exactly what I want):
"select * from table1 LEFT JOIN table2 using(ID) LEFT JOIN table3 using(ID) where ID=1"
What I really want to do, though, is also join table3 to table1, in the (likely) event that table2 does not have a 1:1 relationship with table1.
I'd also like to avoid having to enumerate EVERY field, if possible. Am I asking for too much?
TIA,
chris gonzalez
"select * from table1 LEFT JOIN table2 using(ID) LEFT JOIN table3 using(ID) where ID=1"
What I really want to do, though, is also join table3 to table1, in the (likely) event that table2 does not have a 1:1 relationship with table1.
I'd also like to avoid having to enumerate EVERY field, if possible. Am I asking for too much?
TIA,
chris gonzalez