Want to remove duplicates from a SQL code

[Huddle]

I have the below code but I want to add a grouping to it so that if there is a duplicate building number it will not list it. Is there a way to add a grouping into the code to do this?

SELECT Q_PI_Qrtly_Insp_Ct_Range.District, Q_PI_Qrtly_Insp_Ct_Range.Bldg_Number, Q_PI_Qrtly_Insp_Ct_Range.Bldg_Name, Q_PI_Qrtly_Insp_Ct_Range.Address, Q_PI_Qrtly_Insp_Ct_Range.City, Q_PI_Qrtly_Insp_Ct_Range.State, Q_PI_Qrtly_Insp_Ct_Range.FSL, Count(Q_PI_Qrtly_Insp_Ct_Range.Insp_Date) AS CountOfInsp_Date, Q_PI_Qrtly_Insp_Ct_Range.Due, Lookup_Tbl_Commander_Inspector.Commander
FROM Lookup_Tbl_Commander_Inspector RIGHT JOIN (Q_PI_Qrtly_Insp_Ct_Range LEFT JOIN Tbl_Bldg_Insp_Connector ON Q_PI_Qrtly_Insp_Ct_Range.Bldg_Number = Tbl_Bldg_Insp_Connector.Connecting_Bldg) ON Lookup_Tbl_Commander_Inspector.Inspector = Tbl_Bldg_Insp_Connector.Connecting_Inspector
GROUP BY Q_PI_Qrtly_Insp_Ct_Range.District, Q_PI_Qrtly_Insp_Ct_Range.Bldg_Number, Q_PI_Qrtly_Insp_Ct_Range.Bldg_Name, Q_PI_Qrtly_Insp_Ct_Range.Address, Q_PI_Qrtly_Insp_Ct_Range.City, Q_PI_Qrtly_Insp_Ct_Range.State, Q_PI_Qrtly_Insp_Ct_Range.FSL, Q_PI_Qrtly_Insp_Ct_Range.Due, Lookup_Tbl_Commander_Inspector.Commander;
UNION SELECT Q_PI_Qrtly_Insp_Ct_Range_Null.District, Q_PI_Qrtly_Insp_Ct_Range_Null.Bldg_Number, Q_PI_Qrtly_Insp_Ct_Range_Null.Bldg_Name, Q_PI_Qrtly_Insp_Ct_Range_Null.Address, Q_PI_Qrtly_Insp_Ct_Range_Null.City, Q_PI_Qrtly_Insp_Ct_Range_Null.State, Q_PI_Qrtly_Insp_Ct_Range_Null.FSL, " " AS Blank, Q_PI_Qrtly_Insp_Ct_Range_Null.Due, Lookup_Tbl_Commander_Inspector.Commander
FROM Lookup_Tbl_Commander_Inspector RIGHT JOIN (Q_PI_Qrtly_Insp_Ct_Range_Null LEFT JOIN Tbl_Bldg_Insp_Connector ON Q_PI_Qrtly_Insp_Ct_Range_Null.Bldg_Number = Tbl_Bldg_Insp_Connector.Connecting_Bldg) ON Lookup_Tbl_Commander_Inspector.Inspector = Tbl_Bldg_Insp_Connector.Connecting_Inspector
GROUP BY Q_PI_Qrtly_Insp_Ct_Range_Null.District, Q_PI_Qrtly_Insp_Ct_Range_Null.Bldg_Number, Q_PI_Qrtly_Insp_Ct_Range_Null.Bldg_Name, Q_PI_Qrtly_Insp_Ct_Range_Null.Address, Q_PI_Qrtly_Insp_Ct_Range_Null.City, Q_PI_Qrtly_Insp_Ct_Range_Null.State, Q_PI_Qrtly_Insp_Ct_Range_Null.FSL, Q_PI_Qrtly_Insp_Ct_Range_Null.Due, Lookup_Tbl_Commander_Inspector.Commander;

[June7]

UNION will not allow duplicate records. UNION ALL will allow duplicate records. If any field has different value then the record is not a duplicate and grouping will not eliminate.