Table2 will have multiple records corresponding to a single record in Table1. I want to search in Class_NAME and pull out the corresponding records in Table1.
Table1.AutoInc_ID = Table2.Table1_ID
Table1
AutoInc_ID
Fname
Lname
Table2
AutoInc_ID
Table1_ID
Class_NAME
What kind of select statement will get this done? Thanks for any help that can be provided... Brock