Article:		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. thanks.

Showing messages 1 through 2 of 2.

• Left Outer Join
  2003-08-26 02:38:44  anonymous2 [View]
  
  
• Left Outer Join
  2003-12-09 22:37:54  anonymous2 [View]
  
  
  better if u use inline views in place of inner joins, and then put outerjoin wih that inine view...