Re: Please help with outer join....

Hello Shayne,

Put (+) beside the table entry which may not exist,

 SELECT * FROM CUSTOMERS,FILES,FILEDETAILS,USERS     WHERE CUSTOMERS.CUSTOMERID = FILEDETAILS.CUSTOMERID AND

          FILEDETAILS.FILEID = FILES.FIEID AND
          FILES.OUTBYUSERID = USERS.USERID(+) AND
          FILES.FILEID = 3;

This should work.

Hope this helps
Ken Denny
kendenny_at_bnr.ca (work)
kdenny_at_interpath.com (home) Received on Thu Oct 23 1997 - 00:00:00 CDT