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: Anders Steinlein <dinhelt_at_online.noSPAM>
Date: Fri, 19 Sep 2003 04:18:17 +0200
Message-ID: <MPG.19d485d86d10bc3d9896df@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 Thu Sep 18 2003 - 21:18:17 CDT

Original text of this message

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