T
Tony Williams
I am trying to update the value of a field in a table based on the value of
another with a WHERE clause. Here is my SQL statement:
UPDATE Table1 INNER JOIN Table2 ON Table1.txtVRM = Table2.txtVRM SET
Table1.txtStatus = [Table2].[txtstatus]
WHERE (([Table2].[txtstatus]<>"01"));
I want the value of Table1.txtstatus to be updated to the value of
Table2.txtstatus only where the value of Table2.txtstatus is not 01
Where am I going wrong?
Thanks
Tony
another with a WHERE clause. Here is my SQL statement:
UPDATE Table1 INNER JOIN Table2 ON Table1.txtVRM = Table2.txtVRM SET
Table1.txtStatus = [Table2].[txtstatus]
WHERE (([Table2].[txtstatus]<>"01"));
I want the value of Table1.txtstatus to be updated to the value of
Table2.txtstatus only where the value of Table2.txtstatus is not 01
Where am I going wrong?
Thanks
Tony