Looping the same answer from the 1st row in the table

I have a database with 3 tables: (1) employeeTable (2) cityTable (3)stateTable.

I reference the employee's city name and state code by each id number from the cityTable and stateTable.

My Employee table has about 10 records, 3 has an idcity and idstate input, the rest are blank.

(1st row) id 9 for Henderson, id 28 for NV (6th row) id 9 for Henderson, id 28 for NV, and (10th row) id 10 for Las Vegas, id 28 for NV

I run a query:

<cfquery datasource="dsnName" name="qEmployees">SELECT * FROM users ORDER BY lastName ASC</cfquery>
<cfquery datasource="dsnName" name="qState">SELECT code FROM states WHERE idstate=#qEmployees.idstate#</cfquery>
<cfquery datasource="dsnName" name="qCity">SELECT name FROM cities WHERE idcities=#qEmployees.idcity#</cfquery>

a run the table output:

<table>
    <cfoutput query="qEmployees">
    <tr>
        <td>#qEmployees.lastName#, #qEmployees.firstName#</td>
        <td>#qCity.name#</td>
        <td width="40">#qState.code#</td>
        <td width="60">#qEmployees.zipCode#</td>
    </tr>

     </cfoutput>

</table>

PROBLEM:

All 10 records output in the table as the same answer from the 1st row (Henderson, NV).

What's making this loop having the same answer from the 1st row and affects all the rows with blank info or different info?

I've been trying to figure this out for weeks and I hope the community can help me out. Thanks!