MySQL Forums
Forum List  »  Newbie

How to find all clients with no appointments in the last six months plus
Posted by: Graham Farrell
Date: May 19, 2011 02:31PM

Hi all,

Sorry I'm a bit of a newbie at these types of queries.

I have a table that records appointments for clients which among other fields has a single DATE field called gapmtDate that records the date of the appointment.

Can anyone tell me how I can find all clients whose last visit was greater than six months ago from todays date.

Many thanks in advance.

Irish_Student



Edited 3 time(s). Last edit at 05/19/2011 03:05PM by Graham Farrell.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.