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
