Thanks travis. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 8:27 AM Subject: RE: left join in Oracle
> > SELECT * FROM Parent p, Child c > WHERE p.ParentID = c.ParentID (+) > > man Oracle licks... > > travis > > ---- Original Message ---- > From: Alex Husic <[EMAIL PROTECTED]> > Sent: 2003-02-06 > To: SQL <[EMAIL PROTECTED]> > Subject: left join in Oracle > > Hi all, > > I have a join on two tables that at the moment goes like this: > > SELECT * FROM Parent p, Child c > WHERE p.ParentID *= c.ParentID > > Obviously, I am linking tables at ParentID, but also selecting all rows from > Parent, even if there are no matching ParentID records in the child table. I > am migrating to Oracle and have discovered that *= does not work. Can anyone > help me with a solution that might work in both db platforms? > > Thanks and regards > > Alex > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
