join 3 tables



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.


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

joining tables 1
joining tables 6
Join tables in Access 2
Joining Tables/Queries 1
Join table and subforms 0
Problem joining two tables 1
Join two tables with an expression? 1
Joining Tables Vlookup equivalent? 1