> SELECT name FROM cia WHERE region =
> (SELECT region FROM table WHERE name = 'Brazil');

would be:
 SELECT cia.name
FROM cia, table
WHERE cia.region=table.region
AND table.name='Brazil'

> SELECT name FROM table WHERE count =
> (SELECT max(count) FROM table);

if there may be more than one record having maximum value, you will have to
run two separate queries


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to