Posted By: JiMo (I'm flyiiiiiiing!!!!!!!!!) on 'CZdatabases'
Title:     Re: dotaz na dotaz ;)
Date:      Fri Jun 20 00:55:36 2003

> SELECT Shop FROM sells WHERE COUNT(DISTINCT Cheese) = (SELECT COUNT(DISTINCT
> Name FROM Cheese WHERE Origin = 'UK')
> 
> Pricemz by ten vnorenej dotaz mohl byt i COUNT(*) a mohl bys vynechat ty 
> DISTINCT podle toho jak mas navrhnutou databazi. A mozna na konci jeste musi
> byt GROUP BY Shop (vice mene kombinace sloupcu ktera jednoznacne
> identifikuje  kram, zase zalezi na DB). 

Diky Jerrymu a Tuttlovi za napady. Finalni verze vypada takto:

SELECT sells.Shop FROM sells, Cheese 
    WHERE sells.Ch6eese=Cheese.Name 
    AND Cheese.Origin='UK' GROUP BY sells.Shop 
    HAVING COUNT(*)= (SELECT COUNT(*) FROM Cheese WHERE Origin='UK')

Diky jeste jednou!
 

                        JiMo:)

CONNECT 300^M .....OP^aFD)*HR!hT%UJ0~~!aS&RT&*WQ$*brI&FG^NO CARRIER