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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/228801-update-join-help/#findComment-1179534 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.