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_at_mantis.golden.net>
Date: Thu, 18 Sep 2003 21:27:58 -0400
Message-ID: <ZDuab.216$uO1.20255791_at_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 Fri Sep 19 2003 - 03:27:58 CEST