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
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 !