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