Re: how do i use update in a select query
Well, actually I wasn't that way off :)
This worked:
UPDATE `mzm8e_jomcl_extrafields_values` INNER JOIN `mzm8e_jomcl_adverts` ON `mzm8e_jomcl_extrafields_values`.`advertid` = `mzm8e_jomcl_adverts`.`id` SET value = 2 WHERE (`mzm8e_jomcl_adverts`.`userid`) = 5560 AND (`mzm8e_jomcl_extrafields_values`.`fieldid`) = 5
Many thanks to both of you for trying to help!
Subject
Written By
Posted
Re: how do i use update in a select query
August 14, 2016 02:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.