Need help with a query

[TechnoWeenie]

question, I can't seem to figure this out.

I'm using ASP to access my db.
I have an access db with 2 tables I need to get information from. table 1 has the users information and a user ID field. table 2 has the classes taken by the users and a user ID field which corresponds to the user ID from the table 1. In both tables, the user ID field is called ID.
How do I do a search on the class names in the table 2, grab the ID from the table 2 and match it to the user name in the table 1?

Example:

I'm searching for all the users who have taken a Windows 95 class. I search table 2 for the Windows 95 class from table 2 and get the user ID 4. User ID 4 in table 1 belongs to Joe Smith.

How can I do this in one query statement?

 

[hmckillop]

This is an access question,
But the answer is:

SELECT [Users].[FirstName], [Users].[LastName]
FROM Users, Classes
WHERE 
[Users].[UserID] =  [Classes].[UserID]
AND [Classes].[ClassName] = "Windows 95"

You would need to replace "Windows 95" with a "?" in order to be a passed parameter
Hope this helps


"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.