Noob Question on Updating Data

[FireFett]

Can some one show me how to make a Update Query that updates values from one table with values from another here is a sample of what I am trying to do.

Table one has the following fields
StorageID
Isle
Row
Bin


Table2 has the following field
ToolID
DestIsle
DestRow
DestBin
StorageID

I need to update table2 with contain the storage ID specified in table 1.

 

[checkai]

Based off of what link between the tables...?

 

[FireFett]

DestIsle to Isle
DestRow to Row
DestBin to Bin

 

[ESquared]

UPDATE T1 SET
      T1.StorageID = T2.StorageID
   FROM Table1 T1 INNER JOIN Table2 T2 ON
      T1.Isle = T2.DestIsle
      AND T1.Row = T2.DestRow
      AND T1.Bin = T2.DestBin

 

[FireFett]

Thank You ESquared

 

[ESquared]

You don't actually have to do the inner join, you can just reference table 2 in the from clause and use WHERE instead of ON. But if you need to put more conditions on table 1 then now you know how to do it.

 

[FireFett]

Your example worked great. Thanks for taking the time answering I got the some of the Basics of SQL but there is much more ground to cover