Ron Piggott wrote:
Is it possible to do an UPDATE with an INNER JOIN --- I want the WHERE
to use 2 tables in selecting which rows are going to be updated in
table1.
http://dev.mysql.com/doc/refman/5.0/en/update.html
You can also perform UPDATE operations covering multiple tables.
However, you
Is it possible to do an UPDATE with an INNER JOIN --- I want the WHERE
to use 2 tables in selecting which rows are going to be updated in
table1.
Could you provide me with a simple example if this is possible using the
following variables:
table1 table2 table1.field1 table1.field2 table2.field1