need help converting oracle outer joins into ansi compliant sql

[Quoted] ansi sql experts,

i am trying to convert the following Oracle sql statement into ansi sql compliant statement. any help would be appreciated. Thanks in advance!

select       a.name,b.condition
from         a, b
where       a.id=b.condition_id(+)

Jae Kim Received on Mon Feb 05 2001 - 15:21:30 CET