UPDATE with INNER JOIN?
| From: | Ron Piggott | Date: | Thu, 13 Dec 2007 02:50:15 +0000 |
| Subject: | UPDATE with INNER JOIN? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44405@lists.php.net to get a copy of this message | ||
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
Thanks
Ron