update data into an empty table with the data from another table
I have two tables - XYZ (140 cols.) with no data and ABC (65 cols.) with data.
I need to wirte a sql query in such a way that the data certain cols. in table ABC gets updated into the table XYZ. I do have mapping for the columns. But, there is no Primary key in the first table (XYZ, which is created).
The table XYZ is just a skeleton with absolutely no data in it!
Appreciate the help!
Insert Into XYZ Select ABC.* From ABC;