Rephrase of Question: Select from multiple tables

M

Mark

I think I asked the question improperly last time. I'm very new to
Access so please bear with me.

I have a half dozen or so tables containing different products.
I also have a table containing my users.
Each of the products table has a field titled 'username' .
There may be 0 occurences of a username in the product tables or there
may be many occurances of a username spread out through one, several, or
all products tables.
What I really need to do is figure out the SQL to look through the half
dozen or so products tables to count how many times a given username
occurs.
I'm doing this with ASP, and I can write the code to loop thruogh the
records but can't figure out t he easy way to check all tables with one
select statement, I really don't want to write 6 Select Statements and
keep accessing the Access DB if it's not nessecary.

Is there an easier way?

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top