dflow Posted February 25, 2011 Share Posted February 25, 2011 UPDATE contact_form SET contact_form.CountryID = country_list.CountryID FROM contact_form,country_list WHERE contact_form.CountryName = country_list.CountryName not working Link to comment https://forums.phpfreaks.com/topic/228801-update-join-help/ Share on other sites More sharing options...
dflow Posted February 25, 2011 Author Share Posted February 25, 2011 ok i solved it with the following FYI UPDATE contact_form p LEFT JOIN country_list pp ON p.CountryName = pp.CountryName SET p.CountryID= pp.CountryID WHERE pp.CountryName=p.CountryName Link to comment https://forums.phpfreaks.com/topic/228801-update-join-help/#findComment-1179534 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.