Subtract two queries

[gacca]

Hi,

I wanted to ask whether it is possible to subtract results of one query from other.

In my case, one query produces a list of clients for whom a monthly sales analysis should be made. The second query produces a list of clients for whom monthly analysis is already made. I want to find the list of clients for whom the analysis should be made but is not yet made. I figure i could do that by subtracting the results of the first and second queries.

Thanks,
Gatis

 

[namliam]

For this to work you must have some PK in place...

If so why not use a "simple" subselect or outer join or something? There must be an easier way than you are suggesting...

Regards

 

[raskew]

Call up the new query wizard and select

Find Unmatched Query Wizard.

Just follow the prompts and it should be a cinch.

HTH - Bob