MySQL Outer Join

[IWeb]

Hello,

I want to "simulate" an outer join in standart SQL Syntax (something like SELECT a.FirstAttribute FROM tab a, tab1 b WHERE (a.ID=b.ID OR a.ID IS NULL).).
Is it possible to create such an outer join without using the "JOIN" operators?

Thanks

[rachel2004]

You proably want a nested query (subquery). If you're using MySQL, it depends on the version you are running.

http://dev.mysql.com/doc/mysql/en/Subqueries.html

Otherwise, I think most major dbms support nested queries.

[nemonoman]

What's wrong with an outer join? Once you make the mental jump, it's easy to do. The "simulated" outer join gives me the willies.

SELECT a.FirstAttribute FROM tab a LEFT JOIN tab1 b ON a.ID=b.ID