info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
join 3 tables
6 views
Skip to first unread message
mcnews
Feb 28, 2013, 9:18:06 AM2/28/13
to
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.
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.
0 new messages