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

Many thanks
this worked for me.

Mark

Andreas <anonmeg_at_start.no> wrote in message news:<K8Q_b.1540$EV2.7600_at_amstwist00>...
> Daniel Morgan wrote:
>
> > 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.
> >
>
>
> Sorry
>
> But the part about comparing order.price to null should still apply.
> I think this SQL should solve his problem in 8i as well...
>
> SELECT *
> FROM client, order
> WHERE client.id = order.clientid(+)
> AND (order.price < 10.0 OR order.clientid IS NULL);
>
> (same as in my last post...)
>
>
> Andreas
Received on Wed Feb 25 2004 - 03:34:08 CST