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

Search the boards