SQL Update

[mik706]

I have two tables A and B each table has three fields 1,2 and 3.
What i need to do is update table A field 3 with the value of table B field 3 where A.1 = B.1 and A.2 = B.2 The problem is i have know idea of the SQL statment i need to achive this.

[Lightning]

In case of msSQL

update TableA set TableA.FieldC =  TB.fieldC from TableA TA, TableB TB where TA.PrimKey = TB.ForeignKey

[doofusboy]

Try something like this:

UPDATE Table_A
SET Table_A.Field_3 = Table_B.Filed_3
WHERE Table_A.Field_1 = Table_B.Field_1
AND Table_A.Field_2 = Table_B.Field_2

[mik706]

doofusboy, that is the method i have tried but it just requests a value for TableA.Field_1.

I forgot to add that i am using Access

[leinad31]

Make sure the criteria would return only one record from table B.

[mik706]

I dont want to update just one record, i want to update all the matching records.

[brucevde]

"but it just requests a value for TableA.Field_1."
Then Field_1 is not a fieldname in TableA


Try this MS Access syntax

UPDATE TableA 
INNER JOIN TableB ON TableB.Field1 = TableA.Field1 And TableB.Field2 = TableA.Field2
SET TableA.Field3 = TableB.Field3;