Hi all,

I am responsible for converting an MS Sql database so that it can be imported to multiple database systems (Hypersonic, Postresql, Oracle, etc).

The problem is that a lot of the Ms Sql queries use a variety of outer joins.

I understand that Ms Sql is compliant with the Ansi SQL'92 standard (entry level plus parts of the other levels). I thought Oracle was too.

I have recently found out that there is no simple way to convert the outer joins from Ms Sql to Oracle. Is there any way at all to convert outer joins (ie: unions, intersections, etc)?

Any help would be appreciated.

Thank you in advance.
Best regards,

-Ken