Parameter Query and Not sure of the Join

[Tmat]

I have created a query that shows me who is qualified to teach courses but I have another table with personal restrictions. What I am trying to do is eliminate any one from the qualified list do too their restrictions. I have tried linking and changing the joins and parameters I get some results but nothing good. Is there a better way with SQL?
qryQlfy
TechID Class Day StartTime EndTime Location
1 Bio101 M 7:00 pm 10:00 pm East


tblNonPrf
AntNonPrfID TechID Day Location Time
1 1 M
2 1 F East Evenings
3 2 T Mornings
4 2 M Evenings
On the tblNonPrf the Time field is linked to another table that has Start and End times for Evening and Morning

 

[Amiel]

Done properly, you will have to have a value (a foreign key) such as 'TechId' in the third table (personal restrictions) that will link those records with at least one of the other two tables. If 'startdate' and/or 'enddate' are the only values available for this; you'll probably need to re-structure :-0 that table and add a key to get the results you're after.

Amiel
amielzz@netscape.net