I have what I thought is a simple requirement, but the solution is alluding me.
I have a table tblClients. This links to a table tblJobs via the ClientID.
tblClients has a RenewalDate.
tblJobs has a DateJobReceived.
So I want a list of all clients who are registered (ie RenewalDate > 1/4/18) [say]..
.. who do not have any Jobs since their renewal date (ie count of jobs with DateJobReceived > 1/4/18 = zero)
Can anyone suggest a query that would give me this list please.