Queries from more than one table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

1foxi - 20 Jul 2006 15:22 GMT

I have two tables with information about students. One table for current
students and one for expected students.

Both tables have a field called status. And for each student the status is
different.

I want to create one query that will give me the records from both tables
for each student and their status.

Ie I want to see whose status is say registered but from both tables in one
query. Can anyone help me with this?

Reply to this Message

Rick B - 20 Jul 2006 15:29 GMT

Well, you would create a UNION query, but I would revise the data structure
if I were you.

I would put them all in one table and then add an "active" checkbox or maybe
a "current" checkbox or a "prospect" checkbox. Something to indicate if the
student is active or a prospect.

Your status list could be filtered to only offer choices valid based on this
flag.

Signature

Rick B

>I have two tables with information about students. One table for current
> students and one for expected students.
[quoted text clipped - 9 lines]
> one
> query. Can anyone help me with this?

Reply to this Message