Re: Advanced(?) query question
From: Anders Steinlein <dinhelt_at_online.noSPAM>
Date: Fri, 19 Sep 2003 04:18:17 +0200
Message-ID: <MPG.19d485d86d10bc3d9896df_at_news.online.no>
Date: Fri, 19 Sep 2003 04:18:17 +0200
Message-ID: <MPG.19d485d86d10bc3d9896df_at_news.online.no>
In article <ZDuab.216$uO1.20255791_at_mantis.golden.net>, bbadour_at_golden.net
says...
> >
> > 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.
Okaaay. Care to help me out?
\Anders Received on Fri Sep 19 2003 - 04:18:17 CEST