Queries from more than one table

[Guest]

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?

 

[Rick B]

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.