UNION query using for comparing?

[TjS]

Hello again...

Is it possible to use a UNION query for comparison between to tables or queries?

If so, please advise how to

example:
one query consists of a selection of books, grouped by category for a student
the second query consists of all books, grouped by category for a student

The purpose of the new union query is to check if the student has all the applicable books in his booklist; if the student has forgotten to pick a book for his list, this new query will show the one(s) the student forgot.

Kind of cryptical this example, hope i could make it clear enough...

 

[TjS]

or is it maybe possible to make an "NOT UNION" Query?
(union = combining, not union = differences?)...

It seems to be that access accepts the NOT UNION, but treats it like an UNION query....

hm...how do i do what i want to do?

 

[KeithG]

You dont need a union query. You need a select query with an outer join from the books the stundent has to the all the books they need. Can you postyour SQl;

 

[TjS]

to union or not to union...

i have to make a report that uses a comparison both ways...a loj or roj doesn't help me (unfortunately)..

Putting the sql query here is kind of difficult, because i used just an example and not my real situation (language-problem here in some cases )

Hopefully you can help me in an other way, i need a comparison query also in some other cases too...

 

[TjS]

i managed it though

I managed to solve the case.....

I have made to querys with criteria NotIn; and then i put those two queries in 1 union query...and "voila" the result i wanted was there...

Thanks for the help of course!