Update Query

[vlitim]

Completely lost my mind how do I do this??

first table
AID ATDVID inputvalue
8 16 Age NULL
8 10 Area NULL
8 11 GPS Ref NULL
8 6 Length NULL
8 15 Material NULL
8 7 Width NULL

second table
AID ATDVID inputValue
8 10 2550
8 6 20
8 7 10
8 15 2

I need to update the first tables "inputValue" with the corresponding inputValue from table 2 where AID and ATDVID match.

Cheers
Tim

 

[gradley]

See if this works for you..

Update [First Table]
SET	inputValue = st.inputvalue
FROM [First Table] ft 
JOIN [Second Table] st
on      ft.aid = st.aid
and     ft.atdvid = st.atdvid

 

[vlitim]

yep perfect cheers