[Phpmyadmin-devel] Simulate UPDATE query

Hi, I was working on RFE #861 (Simulate UPDATE query). Lets say I have two tables: `table_1` +----+----------+ | id | value    | +----+----------+ | 10 | value_10 | | 20 | value_20 | +----+----------+ `table_2` +----+----------+ | id | value    | +----+----------+ | 10 | value_10 | | 20 | value_20 | +----+----------+ UPDATE Query: UPDATE table_1, table_2 SET table_1.value = 'NEW_VALUE', table_2.value='NEW_VALUE' WHERE table_1.id > 10 AND table_2.id > 10; This will affect 2 rows. How to simulate this query using SELECT statement? I was trying: SELECT DISTINCT table_1.value, table_2.value FROM table_1, table_2 WHERE table_1.value <> 'NEW_VALUE' AND table_2.value <> 'NEW_VAUE' AND table_1.id > 10 AND table_2.id > 10; but this only returns 1 row. Can this be done in a single query only?   Regards, Ashutosh Dhundhara