> 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
Sigitas
--
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]