Just +=, it is advisable not to use it as it may not work in future versions.
-----Original Message----- From: Alex Husic [mailto:[EMAIL PROTECTED]] Sent: 07 February 2003 06:55 To: SQL Subject: Re: left join in Oracle Do you mean the whole = thing is deprecated or just += ? Alex ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 9:11 AM Subject: RE: left join in Oracle > > *=, this is not advised anyway... its deprecated and may not feature in > future releases of SQL Server. > > -----Original Message----- > From: Alex Husic [mailto:[EMAIL PROTECTED]] > Sent: 06 February 2003 07:16 > To: SQL > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
