sql select where condition question

[sql8888]

I saw a select statement like this:
select a.name, b.street from a, b where a.ad_uid = b.ad_uid(+)

what is the (+) mean? anyone can explain it? thank you in advande

 

[PHV]

It's an OUTER JOIN for some RDBMS.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886