Help with query

[Ronan Lucio]

Hello,

A have two tables:

City:
    CityID
    CityName

Client:
    ClientID
    ClienteName
    CityID

How can I make a SELECT that returns me only the cities
that have more than 30 (example) clients?

Thanks,
Ronan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]