Subject | outer join help |
---|---|
Author | Ed Dressel |
Post date | 2007-04-25T22:42:19Z |
This is pretty simple, I seldom use outer joins. I need two levels of
outer joins:
Table1
+ Table2 [outer]
+ Table3 [outer]
but I can not get the second one to work. My SQL is below:
select ...
from Table1 T1 left join Table2 on T1.Table1_ID = Table2.Table1_ID,
Table2 outer join Table3 T3 on Table2.Table2_ID = T3.Table2_ID
where ...
I've tried various forms of it, some which lock up my application.
What is the SQL?
outer joins:
Table1
+ Table2 [outer]
+ Table3 [outer]
but I can not get the second one to work. My SQL is below:
select ...
from Table1 T1 left join Table2 on T1.Table1_ID = Table2.Table1_ID,
Table2 outer join Table3 T3 on Table2.Table2_ID = T3.Table2_ID
where ...
I've tried various forms of it, some which lock up my application.
What is the SQL?