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