Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: criteria on the outer table
I would go so far as to say it is a homework assignment in an OO programming
class where they are just beginning to learn about SQL.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D874A50.47FD05D7_at_exesolutions.com...
> "sit.sit" wrote:
>
> > I have 2 tables
> >
> > obj
> >
> > code
> > description
> >
> > and
> >
> > evt
> >
> > object
> > event
> > date
> >
> > join by the outer join evt_object(+)=obj_code
> >
> > criteria= where evt_date between :p_start and :p_end
> >
> > i want to select all the obj_code and description of the obj table
> > , count the number of events for each obj_code even when no event
> > exist during the period (criteria on the outer join)
> >
> > how can i do?
>
> I presume this is homework ... and therefore suggest that you open your
> textbook and read it for examples.
>
> If my presumption is incorrect ... then I suggest you purchase a good
> beginners book (no insult intended) such as Oracle for Dummies.
>
> BTW: Your syntax above is incorrect. It should be evt dot object ... not
> evt underscore object.
>
> Daniel Morgan
>
Received on Tue Sep 17 2002 - 12:22:41 CDT