Update, Append or Insert I am not sure

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello

I am not sure what type of query I need since none of them are working
for me.

I need to insert on my table1.Field13 the information on
table2.Field13 where table1.Field2 = table2.Field2
table1.Field2 has the same ID numbers as table2.Field13

I am not sure which way to do it.

Thanks
Bob
 
Sounds like an update query.

UPDATE Table1 Inner Join Table2
ON Table1.Field2 = Table2.Field2
SET table1.Field13 = Table2.Field13

I may have gotten lost in your verbiage, but this should give you the idea.
 
That did it

Thank you very much. Sorry about the way I was trying to explain. I
confuse myself even more

Bob
 
Back
Top