mrtauntaun
MIS
I need to update table1 with data from table2 using an update query. The problem is there is no field in table1 for me to update to. I want the query to create a new field in table1 so I then have a valid target to update the data too.
Example:
Table2 has a field named 'DataField'
Create [Table1].[Datafield] and update data from [Table2].[Datafield] to [Table1].[Datafield]
Note that Table1 and Table2 are joined by primary key, where both fields are equal (solid join).
Thank you!
Example:
Table2 has a field named 'DataField'
Create [Table1].[Datafield] and update data from [Table2].[Datafield] to [Table1].[Datafield]
Note that Table1 and Table2 are joined by primary key, where both fields are equal (solid join).
Thank you!