Hi all,
I have two table with matching structures and I want to compare records between the two tables where field 1 is identical. However on one table some of the records appear more that once.
eg:
TBL1
Field 1 Field 2 Field 3
A _____x_____ x
C _____x_____ x
D _____x_____ y
TBL2
Field 1 Field 2 Field 3
A_____ x_____ x
C _____x_____ x
D _____x_____ y
I want records that dont match to then be shown.
Ie
Field 1 Field 2 Field 3 Field 4 (difference)
D _______x______y______ x
Is this possible?