What you are looking for is not a UNION query. A UNION query merges like
data from multiple record sources into a single result set. In my
experience, it's most common use is to normalize a poorly structured database.
I believe what you want to do is create a query that links your Customer
table (Table1) to the Territory table (table2) and the Broker table (table3).
You have not indicated how these tables are related, so it is difficult to
answer your question. If you provide a little more information about your
table structure, you will get considerably more help. At this point, all we
can do is speculate.
If I were designing this database, I would probably have a Customer table,
that contains a CustomerID field, it might also have a ZipCode or some other
indicator to indicate what Territory the customer resides or does business
in. The Territory table, IMHO, would probably contain specific information
about territories (maybe ZipCodes or TerritoryID and would have some sort of
description field, like "S.W. Illinois"). The Brokers table might have a
TerritoryID field, or if a Broker is responsible for more than one territory,
you might also have a BrokerTerritory table which would give you the ability
to assign brokers to multiple territories.
If you provide a little more information about your table structure, you
will get considerably more help. At this point, all we can do is speculate.
Dale
