SELECT from multpile tables

M

Mark

A quick (hopefully!) question.
How can I use SELECT to look at mulitple tables?
Example: I have several tables of products, all containing a field
called username. This tables are linked to A UserTable containing the
Users data. Many to one relationship.

What I want to do is: Look at each of the products table's username
field for occurances of a particular username.

There will possibly be serveral occurances of the username being
searched for in any of the products tables.

I'm just starting to learn SQL. It's become nessecary to my being able
to teach myself ASP and ASP.Net, one thing leads to another.......

Thanks,
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

Rephrase of Question: Select from multiple tables 1
Can not create form from 2 tables? 3
Select From choice of tables 3
Multi-valued fields are not allowed in SELECT INTO statements (A20 0
Selecting from a database where the joins have history 1
Information retrieval based on non-unique fields across separate tables 5
Select all entry data from two linked (with a relationship) Tables 4
relationships/ tables 4

Top