Hello Friends,

I've recently bumped into a problem when porting a small application from SQL Server to Oracle. The application uses quite a number of sql statements with INNER and OUTER JOIN syntax. While pure INNER JOINS are easy to rewrite by specifing the JOIN condition in WHERE clause, how to deal with OUTER JOINS?

For example: sql statement

SELECT * FROM A LEFT OUTER JOIN B ON A.ID = B.ID

How to implement it in Oracle? Also, I connect to Oracle using Oracle ODBC Driver - shouldn't it support ANSI SQL syntax? Why doesn't it recognize INNER and OUTER JOINS?

Thank you for your replies!