I am trying to create a query that will pull tax rates into transactions for the entire U.S. The issue I have run into is there are multiple states that have the same counties and cites and are pulling different rates. Example Decatur TX will pull in the Decatur AL rate. What can I do to stop this?

```
SELECT 
Query1.STORE_NUM, Query1.ST_CD, 
Query1.[Juris Cd], Query1.CITY_NM, Query1.[Document Date], 
Query1.[Amount in local currency], Query1.[Rental Tax], 
Query1.[State Rate], Query1.[County Rate],
IIf(IsNull([City_Rates].[City_Rate]),0,[City_Rates].[City_Rate]) AS [City Rate]

FROM 
Query1 LEFT JOIN City_Rates ON Query1.CITY_NM = City_Rates.City

WHERE 
(((Query1.ST_CD)="GA"));

```