Re: many to many LEFT JOIN
Posted by:
cadex
Date: July 12, 2005 07:23PM
Sorry for the long delay, and thanks so much for helping. I've tried what you said about making the second JOIN just a regular JOIN and not a LEFT JOIN but then it seems to only give me those store which actually have an entry in the nis_completion table. If I leave the LEFT JOIN as is, it seems to give me everything in the nis_completion table (all projects for every store, regardless of whether I asked for them or not), and it also gives me all the stores (which is good, because I want that).
I'm pretty stumped....
Please, if anyone has any ideas, crazy or not, I'll be happy to try them.
Thanks a million
Kyle
Subject
Written By
Posted
Re: many to many LEFT JOIN
July 12, 2005 07:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.