no there are examples in the book using where 'not exists'. the query was horrible. Ill post it later if you want to see how bad it is.
no its not homework. Id get the answer wrong if i did it this way, since Id have to follow the model in the book. Which is terrible. > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon PM 12:29:40 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: interesting sql question > > yeah! I think it *is* homework!!!! :) > > Tom > > > -----Original Message----- > Sent: Monday, September 29, 2003 12:10 PM > To: Multiple recipients of list ORACLE-L > > > > Hey ... the question wasn't complete ... > > give us the full statement of the question ... > <g> > Raj > ---------------------------------------------------------------------------- > ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > > Sent: Monday, September 29, 2003 11:55 AM > To: Multiple recipients of list ORACLE-L > > > a user may request the same boat more than once. not sure that work. > > > > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > > Date: 2003/09/29 Mon AM 10:34:53 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: RE: interesting sql question > > > > Here is an attempt ... > > > > select p.* > > from persons p > > where sid in > > (select sid, count(bid) > > from bids > > group by sid > > having count(sid) = (select count(boad_id) from boats)) > > / > > > > You wanted to find all persons who have booked all boats ... add criteria > > for booked in the first sub-query. > > > > Raj > > > ---------------------------------------------------------------------------- > > > ---- > > Rajendra dot Jamadagni at nospamespn dot com > > All Views expressed in this email are strictly personal. > > QOTD: Any clod can have facts, having an opinion is an art ! > > > > > > >Title: RE: RE: interesting sql question
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: interesting sql question
Hey ... the question wasn't complete ...
give us the full statement of the question ...
<g>
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: interesting sql question
a user may request the same boat more than once. not sure that work.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon AM 10:34:53 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: interesting sql question
>
> Here is an attempt ...
>
> select p.*
> from persons p
> where sid in
> (select sid, count(bid)
> from bids
> group by sid
> having count(sid) = (select count(boad_id) from boats))
> /
>
> You wanted to find all persons who have booked all boats ... add criteria
> for booked in the first sub-query.
>
> Raj
> ----------------------------------------------------------------------------
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
