I have two tables in Access that have the exact same columns but different data. I want to query Table A and Table B to find all records with duplicate values in Column A (lets say there are Columns A-Z). I want to perform a Group By function so that i don't see multiple results for the same duplicate records. I have successfully done this by joining Table A and Table be ON Column A and only showing Column A with a Group By applied. However, i also need to show Columns B-Z. How do i add these columns and still keep the Group By on Column A.
I also tried using the DISTINCT operator in the Select clause, but again, i don't know how to only apply the DISTINCT to Column A.
SELECT Distinct Table_A.[Column1]
FROM Table_A. INNER JOIN Table_B ON Table_A.[Column1] =Table_B.[Column1]
Result = 3647
Do i need to make this query in two passes, 1 to find the duplicates, 2 to perform the group by?