||The Outer Limits of SQL JOINs|
|Subject:||Left Outer Join|
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.