I want to compare and display the results of 2 queries

[tforrest79]

Hi I have 2 queries

1. customers where movement date is >= 01/04/06
2. customer where order date is >= 01/04/06

The 2 queries are based on the same table however as you can see in the title states that each query has different criteria.

1 .customers where movement date is >= 01/04/06 has 1502 records

2. customer where order date is >= 01/04/06 has 1486 records.

Ive applied a distinct to each query above to identify indivual customers. I get two different results and would now like to understand how I can compare the results by my customer reference field as both tables have this field.

I want to list any customers that do not match. This will tell me what customers have ordered a products from me since 1st apr 2006 but the product has not actually moved.

Hope you can help.

Kind regards,
Tom

 

[lespaul]

Have you looked into the Unmatched Wizard

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[PWise]

Select *
from qryOrderyDate
left join qrymovementdate
on qryOrderyDate.customerid=qrymovementdate.customerid
where qrymovementdate.customerid is null