Union SQL (1 Viewer)

[paulcherianc]

Dear Experts!

From the below SQL Query i need to get the unique records. Could anyone help me !

SELECT [Cost Center],[Employee Backcharge]
FROM [Accommodation Module-6-LRT Employee Backcharge by Cost Center 2];
UNION
SELECT [Cost Centers],[Sum of Total Amount]
FROM [Accommodation Module-6-LRT Project Backcharge by Cost Center];

 

[Galaxiom]

A UNION should already remove duplicates of records that are in both queries suggesting that you have repeats in the source tables or queries.

Put DISTINCT after SELECT in both queries.