> 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