Re: LEFT JOIN (+) problems

Hi Phil,

almost absolutely correct :)
Just add the outer join operator (+) as marked below.

"Philippe Legault" wrote...
<snip some stuff>
> Now if I only want the ones from July 5th 2002, I would think of doing
> something like:
>
> select * from intrvl_hh,a where intrvl_hh.interval=a.interval(+) AND
> a.daterapport = TO_DATE('5-Jul-2002','dd-mon-yyyy') order by

a.daterapport(+) = TO_DATE('5-Jul-2002','dd-mon-yyyy') order by

                    ^^^

> intrvl_hh.interval;
 <snip>
> Thanks,
>
> Phil

Hth and greetings,
Guido Received on Tue Jul 23 2002 - 10:38:19 CEST