COMPLICATED UPDATE

[Diana Castillo]

how do I make a query that does this?
update tbl_a set location_code=0 where tbl_a.country_id = (select id from 
countries where has_zones=0) 

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