*=, 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
