Updating based on a field in a different table

akrashdi · #1 (**permalink**) 09-26-11, 02:47

Hi,

I am having trouble figuring out how to update values of many records in a table.

node (table)
nid
type
comment

node_revision (table)
nid
comment

I wanna do something like:

Code:

UPDATE node_revision SET node_revision.comment=2 WHERE node.nid = node_revision.nid AND node.type='ct_geography'

I mean `node_revision` table does not have 'type' column, but `node` table has it. How do I update `node_revision` based on `node` field?

Appreciated...

r937 · #2 (**permalink**) 09-26-11, 04:38

Code:

UPDATE node_revision 
INNER
  JOIN node
    ON node.nid = node_revision.nid
   SET node_revision.comment = 2 
 WHERE node.type = 'ct_geography'

akrashdi · #3 (**permalink**) 09-26-11, 06:17

Awesome, nice breakdown of the query, it helped understand it.

Internet Services

Web Development

Digital Marketing

Consumer Tech