query from two tables

[Guest]

Database for vendors that represent different websites in different states
and counties. I have a query that will list all vendors from various
websites, states, counties. Some vendors are members of different sites and
or states. The query works perfect for the information that I need. However I
am having difficulty 'matching' a single record with single record in another
table. The other table has three fields (order_website, order_state,
order,county) How can I run a query against the ALL query/table. Currently
what happens is that it will show everyone that is part of either
website_name, or state, or county. I need this to break it down to a single
record

Can I ceate some criteria that says that
order_website,order_state,order_county in the order table HAVE to match
website_name, state, county in the all salesmen table/query?

Thanks,
Jack

 

[Ken Snell [MVP]]

You need three joins between the "order" table and the other table/query.
Sounds as if you've got just one. Join all the fields that need to match
between the two source tables. After you do this, you should see three
joining lines in the design view.