The Outer Limits of SQL JOINs
Subject:   Left Outer Join
Date:   2001-12-24 07:16:59
From:   shevyb
I am having a problem with a sql statement which i am trying to run. I am doing a left outer join and then i am also doing 2 other inner joins in the same select statment. when i do all this together i get the correct amount of rows however the information from the table which i am outer joining to always comes up as null. I found that when i eliminate the other 2 inner joins then i get the information.
I would appreciate if you can help me with this.

1 to 1 of 1
1 to 1 of 1