duplicate vendor address

[ETjoumas]

Hello, I'm trying to identify vendors with the same address and I'm trying capture Address Line 1 and Address Line 2 in my SQL but I'm getting an error. Can someone take a look and let me know what I'm missing.

SELECT *
FROM [Dup Vendor] AS PH1
WHERE (Exists (SELECT *
FROM [Dup Vendor] AS PH2


WHERE PH2.[ID] <> PH1.[ID]
AND PH2.[Address Line 1 & Address Line 2] = PH1.[Address Line 1 & Address Line 2]));

[ranman256]

did you try the FIND DUPLICATES WIZARD? (when you click new query button)

[ETjoumas]

Yes, but I can't export that with the columns I need.

[orange]

Please tell us about your tables and fields and then exactly "the columns I need."