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
You can also perform UPDATE operations covering multiple tables.
However, you cannot use ORDER BY or LIMIT with a multiple-table UPDATE.
The table_references clause lists the tables involved in the join. Its
syntax is described in Section 22.214.171.124, “JOIN Syntax”. Here is an example:
UPDATE items,month SET items.price=month.price
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php