Re: how do i use update in a select query
Hi,
that would've probably worked as well, even though I don't completely understand the syntax...
I had just replied to DJ L that I had finally done it this way:
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:56PM
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.