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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php