Home -> Usenet -> comp.databases.oracle -> Re: SQL:Joining same table more than once

Re: SQL:Joining same table more than once

From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 1995/12/13
Message-ID: <4amtap$ko4$7_at_mhafm.production.compuserve.com>#1/1 







I haven't tried what you're doing but it strikes me that you need 
to do an outer join rather than COL IS NULL. Problem is that you 
can only outer join one table to another once per query.



HTH



-- 
Steve Edelstein                      VOICE: 212-956-3670
Relational Business Systems          CompuServe: 74160,645
124 West 60th Street  Suite 47C            Author of
New York, NY 10023                    "Learning Oracle Forms"


Received on Wed Dec 13 1995 - 00:00:00 CET












Original text of this message