|Date:||Tue, 21 Aug 2007|
One tricky question
I have a two tables - one is a source data and the second one is a new data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes
Record Table Heading
1 Source Department
1 New Department
I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?