Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Advanced(?) query question

Re: Advanced(?) query question

From: Bob Badour <bbadour_at_golden.net>
Date: Thu, 18 Sep 2003 21:27:58 -0400
Message-ID: <ZDuab.216$uO1.20255791@mantis.golden.net>


"Anders Steinlein" <dinhelt_at_online.noSPAM> wrote in message news:MPG.19d4790bf8c57019896dd_at_news.online.no...
> I'm not sure I've come to the right place, so any help would be most
> appreciated.
>
> In two tables, cities and countries, the first references the latter
> (foreign key). I want to retrieve the country ids (the column shared by
> both tables) where the values in the password column in the countries
> table is null, but those country ids found should not have more than 10
> occurences in the cities table.
>
> Can this be done?

Yes. Received on Thu Sep 18 2003 - 20:27:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US