Can I do this in MySQL with phpMyAdmin..
UPDATE farecompare SET farecompare.depcity = airportcodes.city WHERE farecompare.depcode = airportcodes.iatacode
farecompare and a airportcodes are 2 tables that sit in the same DB
RTFM....
http://dev.mysql.com/doc/mysql/en/UPDATE.html Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables: UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
http://dev.mysql.com/doc/mysql/en/UPDATE.html Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables:
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
Cheers thanks...
