| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Advanced(?) query question
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 Thu Sep 18 2003 - 21:18:17 CDT
![]() |
![]() |