Women in Technology

Hear us Roar



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.
Main Topics Newest First

Showing messages 1 through 1 of 1.

  • Left Outer Join
    2003-08-26 02:38:44  anonymous2 [View]