Insert data into a table from another table

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

SSC-Dedicated

Points: 39972

March 19, 2011 at 10:36 pm

"JOIN" is what u are after 🙂

henryvuong1000 SSC Eights! Points: 821 More actions · Answer 2

Can you be more specific? Please note that I want to actually fill the data into the table, not just "join" the two tables for an output. Thanks

UMG Developer SSChampion Points: 13482 More actions · Answer 3

There are a couple ways to do what you are looking for, here is one:

UPDATE S

SET

Address1 = A.Address1,

Address2 = A.Address2

FROM Sales S

INNER JOIN Addresses A

ON S.AddressID = A.AddressID;

Of course I have no idea why you would want to duplicate the address information...