C# Find Duplicate Values in a Datatable

Simply use a UNION

SELECT [Person] as [Perdson],[Billing Street] as [Street], [Billing City] as [City] FROM Tbl
UNION
SELECT [Person],[Home Street] [Home City] from tbl

Leave a Comment