Need to select records that match and then those that don't match from the 2 tables (See attached)
Would like to compare Table A statid to Table B statid and if those don't match, try to match on Table A id2 with TableB Id2 (or vice versa..whatever works).
I have to account for NULLS and blanks in the statid & id2 fields. I have thousands of recs in each file.
Thank you! AandBFiles.xls