MySQL :: UPDATE using SELECT
Coming from an Oracle background I am used to doing this: UPDATE accomodation a SET a.country = (SELECT c.country FROM country c WHERE c.country_id = a.country_id); I could not ge thtis to work so looked up the syntax for this: update accomodation a...