SELECT *, "Y" as match FROM tableA ; WHERE first_name + last_name NOT IN ( ; SELECT first_name + last_name FROM tableB) ; UNION ALL ; SELECT *, "N" as match FROM tableA ; WHERE first_name + last_name IN ( ; SELECT first_name + last_name FROM tableB) ; INTO CURSOR crsA READWRITE>Is there anyway to also bring over the names that matched too?