join 3 tables

M

mcnews

I have a student table and need to filter it based on existing records on two other one to many tables. the two other tables will contain a student_id and a signdate. so I only need the most recent signdate so that I only get one record.
actually I only need to know if a matching student_id exists in each of these two tables.
I can't seem to work it out. I can get the syntax for one sub query but not two.
need help.
tia,
mcnewsw8.
 

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

Top