Re: LEFT JOIN (+) problems
From: Guido Konsolke <gk61_at_gmx.net>
Date: Tue, 23 Jul 2002 10:38:19 +0200
Message-ID: <1027412734.85147_at_news.thyssen.com>
Date: Tue, 23 Jul 2002 10:38:19 +0200
Message-ID: <1027412734.85147_at_news.thyssen.com>
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