I have 2 indentical Data Extensions say table1 & table2. email is the primary key in both these Data extensions
I run below query to update Data extension table2
select * from table1
The query completes successfully without errors but the data from table1 is not updated into table2.
But when I manually write each field from table 1 without using select *, the data is updated correctly
Please can anyone help me solve this issue, as I need to use select * and not manually enter all fields due to the use case in the project. Any other way to resolve this ? I do not want to overwrite this table2 as well as i want to retain original row numbers