Query 2 tables

[ThomP]

Good morning all,

I have 2 tables, 1 w/ gender, age, zip, state and the other that has rural
zip codes and state.

I need to create a query that will give me only the gender, age, and return
only the rural zip codes and state. Make Sense

Thanks in advance

 

[John Spencer]

Sounds like a simple INNER JOIN query to me.

Add both tables to your query
Drag from Zip to Zip to set up a join between the zip codes.
In most cases that should be all you need since I don't know of zip codes that
cross state boundaries.
If you are truly cautious you can also drag from State to State. Add the
field you want to set from table 1.

The SQL statement would look something like

SELECT Table1.Age, Table1.Gender
FROM Table1 INNER JOIN TableRural
On Table1.Zip = TableRural.[Zip Code]
AND Table1.State = TableRural.State

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County