JOIN migration from Oracle to MySQL

Hello,

I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:

select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...

MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same table aren't accepted.

example:
select ...
from
tableA PT1 LEFT OUTER JOIN tableC bl ON (PT1.ID = bl.PARENTTYPE_1), tableB PT2 LEFT OUTER JOIN tableC bl ON (and PT2.ID = bl.PARENTTYPE_2), ...

-> doesnt' work.

Exits a solution for this example? Other syntax possibilities?

regards,
Spiker

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kanns mit allen: 
http://www.gmx.net/de/go/multimessenger

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek