Thanks. That's a great tip.
----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 9:26 AM Subject: RE: left join in Oracle > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
