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>


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

Original text of this message