Difficult query

[duetltd]

I need to create a list of customers that have not been called upon within a period of time.

 

Customers: CusID  Name etc.

Calls: CusID  Date Sales Rep etc.

 

Is this possible using sql or should I just write a program to do this?

 

Thank you for your help.

 

Don Lareau

 

[Ken2k7]

It's possible. Assuming the `Date` field is of a date type, you can use this example:

 

This selects all customers that have not received calls in the past 30+ days.

SELECT cu.Name, ca.CusID

FROM Customers cu

INNER JOIN Calls ca

    ON (cu.CusID = ca.CusID)

WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) > ca.Date;

[duetltd]

Thank you, however this excludes customers with no records in the detail file.

[PFMaBiSmAd]

Use -

LEFT JOIN