-2

I'm trying to select all the records from columns in a table1 and replace 1 column with the other column from the other table...

it is possible?

select * from tbl1
replace tbl1.col1 with tbl2.col2
DjayPediA
  • 17
  • 1
  • 9
  • 1
    "Write code for me" requests are not acceptable here on StackOverflow. Break your task into smaller tasks, read the documentation for each of the components required, look for similar examples and try to understand how they work, write the code, and then if you have a specific question about it, come back here. – RealSkeptic Jul 30 '15 at 16:31

1 Answers1

0

I think the adding an IF or WHERE not exists to the INSERT statement as described here might work:

INSERT VALUES WHERE NOT EXISTS

Community
  • 1
  • 1
WillShackleford
  • 6,918
  • 2
  • 17
  • 33