Posted By: jerryiii (Vsude dobre, v CR nejhur) on 'CZdatabases' Title: Re: dotaz na dotaz ;) Date: Fri Jun 20 00:57:05 2003 > 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! Jojo, ja si az na ceste do prace uvedomil ze musim kontrolovat zemi cheese i na ty tabulce shopu... > JiMo:) > > CONNECT 300^M .....OP^aFD)*HR!hT%UJ0~~!aS&RT&*WQ$*brI&FG^NO CARRIER Jerry III Enough said ... http://jerryiii.home.sprynet.com/mica/index.htm