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.