Re: LEFT JOIN (+) problems
From: Robert Boyle <rboyle_at_cyantel.com>
Date: 23 Jul 2002 01:36:59 -0700
Message-ID: <8729a6fe.0207230036.74ebddb1_at_posting.google.com>
1:00
Date: 23 Jul 2002 01:36:59 -0700
Message-ID: <8729a6fe.0207230036.74ebddb1_at_posting.google.com>
Phil,
You need to add an outer join condition on daterapport too. Such as:
robert_at_CTD1>SELECT *
2 FROM intrvl_hh, a
3 WHERE intrvl_hh.interval = a.interval(+)
4 AND a.daterapport(+) = TO_DATE('5-Jul-2002','dd-mon-yyyy')
5 ORDER BY intrvl_hh.interval;
INTER DATERAPPO INTER CALLS
----- --------- ----- ----------
00:00 00:30 01:00 01:30 02:00 02:30 03:00 03:30 04:00 04:30 05:00 05:30 06:00 06:30 05-JUL-02 06:30 23 07:00 07:30 08:00 08:30 09:00 09:30 05-JUL-02 09:30 12 10:00 10:30 11:00 11:30 12:00 12:30 13:00 13:30 14:00 14:30 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:30 19:00 19:30
1:00
20:00 20:30 21:00 21:30 22:00 22:30 23:00 23:30
49 rows selected.
HTH
Robert
Received on Tue Jul 23 2002 - 10:36:59 CEST