I have two identicle tables, that have two index fields, Type and Code. Both of these fields can have the same value in the respected field but not a unique match where two records in the same table have the same values for both Type and Code.
TableA
Type=A Code=101
Type=A Code=102
Type=A...
I'm wanting to compare two tables and pull out the non matching records from table A that does not exist in table B. The two tables have a common Field in each of them.
Thanks
Michael
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.