Copy from table1 to table 2 while matching IDs

compsci · #1 (**permalink**) 11-07-08, 16:26

Hello all,

I have two tables. I have simplified it to:

table1: ID, fromEmail
table2: ID, fromEmail (blank Column)

The ID's of table1 and table2 match, there may be repeated in table2. I want the email fields copied to table2 that have the same ID as table1. I have this so far.

Code:

INSERT INTO table2.fromEmail WHERE table2.ID=table2.ID

Of course that won't do it but I don't know how to get the data from table1. Do I use a select statament? I am so thick

Thank you for any help and direction

r937 · #2 (**permalink**) 11-07-08, 19:31

try this --

Code:

UPDATE table1
INNER
  JOIN table2
    ON table2.ID = table1.ID
   SET table2.fromEmail = table1.fromEmail

compsci · #3 (**permalink**) 11-08-08, 12:34

Aaah that did it! Thank you! You are a blessing to many forums. I've repped you on another forum for this

ankur02018 · #4 (**permalink**) 11-10-08, 05:11

Quote:

Originally Posted by r937

try this --

Code:

UPDATE table1
INNER
  JOIN table2
    ON table2.ID = table1.ID
   SET table2.fromEmail = table1.fromEmail

or

UPDATE table1,table2 SET table2.fromEmail=table1.fromEmail where table2.ID = table1.ID;

r937 · #5 (**permalink**) 11-10-08, 06:22

yeah, but ankur, you're still using an inner join, only using the older, deprecated style instead of the newer, recommended JOIN syntax

Internet Services

Web Development

Digital Marketing

Consumer Tech