Re: Help with ANSI SQL and Oracle 8i

Called an outer join in Oracle
select * from a,b
where a.id(+)=b.id

SW wrote in message <7nmqo1$le1$1_at_fe2.cs.interbusiness.it>...
>Hi,
>
>I need to make a query like this:
>
>select *
>from a left join b
>where a.id = b.id
>
>
>I want to use the ANSI SQL92 syntax and not the Oracle syntax
>
>Can someone help me?
>
>Thanks
>
>
>
>
>
Received on Wed Jul 28 1999 - 07:29:03 CDT