Re: how do i use update in a select query
Hi,
The table mzm8e_jomcl_extrafields_values has 6 extrafields for each entry in table mzm8e_jomcl_adverts, they are identified by column "fieldid" (values 1-6).
I.e. if table mzm8e_jomcl_adverts would have 100 entries, table mzm8e_jomcl_extrafields_values would have 600 entries.
I need to change the value of "fieldid" value 5.
As I have written, I managed to "filter" the things I need to change through the SELECT query, I just don't know the syntax to UPDATE the value of the "results" from the SELECT query.
I HOPE I have made myself clear enough...
Many thanks for your interest in my problem!
Subject
Written By
Posted
Re: how do i use update in a select query
August 14, 2016 01:05PM
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.