"Steve Myers" <stephencmyers_at_hotmail.com> wrote in message
news:3e0c4493.0307250653.3b3d7951_at_posting.google.com...
> I'm porting some Oracle views to SQL Server. Not being a Oracle dba,
> I'm having a problem with the syntax in one of the views. In a view, I
> see this in one of the where clauses:
>
> where x.field = y.field(+)
>
>
> What does the (+) do? Is this some function?
It's an obsoleted outer join operator, I think particualr to Oracle. The
equivalent for SQL Server would be a left [outer] join.
Received on Fri Jul 25 2003 - 10:39:32 CDT
