I need to update rows of a table based on values in another. I've googled this all morning but cant find anything useful.
I have Select statement where I can see all the records I need to update (below) but I cant seem to make an update query that updates only the records that are returned by the select statement.
Select tblA_CommonFeild, tblA_NeedsChanging, tblB_ReferenceFeild
From tblA, tblB
WHERE tblB_CommonFeild=tblA_CommonFeild AND tblB_ReferenceFeild = 'NewValue' AND tblA_NeedsChanging='OldValue'