Re: Simple How To: SQL left Join with and clause

Andreas wrote:
> joes wrote:
>

>> Hello there
>> I try to rewrite an Access queries for Oracle 8. Now I get in touch
>> with 'LEFT JOIN' and need there some little hint how to do that.

> You don't need to rewrite that much. Left join are ANSI standard, so
> this sould be valid.
> SELECT *
> FROM client LEFT JOIN order
> ON (client.id = order.clientid)
> WHERE order.price < 10.0;

Did you read what the OP wrote? Notice he said "for Oracle 8". What you posted will not work in any version or edition of Oracle 8.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)