Hey Guys,
I have two tables that I want to compare based on a single field. Both tables are exactly the same except for 3 columns that were added in table B.
So basically I want to take table A and say if Field1 in table A matches field1 in table B, ok but check the rest of the columns to make sure they match.
If field 1 in table A doesn't match anything in table B, add the record to table B with null values in for the 3 columns that are different.
Does anyone have any suggestions on the best way to do this? Thanks so much for any help, it is greatly appreciated.
I have two tables that I want to compare based on a single field. Both tables are exactly the same except for 3 columns that were added in table B.
So basically I want to take table A and say if Field1 in table A matches field1 in table B, ok but check the rest of the columns to make sure they match.
If field 1 in table A doesn't match anything in table B, add the record to table B with null values in for the 3 columns that are different.
Does anyone have any suggestions on the best way to do this? Thanks so much for any help, it is greatly appreciated.