I have an SQL query that is producing overstated records. I have 2 tables, History_1 and History_2 tables. History 1 has multiple data rows matching Call_ID which is creating overstated results. What I need to happen is only to match against 1 of the mutiple data matching records to produce accurate results. I have attached the SQL Syntax. Thanks.
Facility_Name As "Facility",
History_1.Client As "Client",
Count(History_1.Client) As "Count"
History_1.Call_ID = History_2.Call_ID and
History_1.Client = LU_Clients.Facility_ID