MySQL Forums
Forum List  »  Newbie

Can not workout how to do this!
Posted by: Roberto Cano Ramos
Date: April 26, 2005 06:50AM

Hi!
I have a appointment table with 4 field id (identity) , id_patient (integer) , appoinment (Datetime), arrived (Datetime) .

The field of interest is "arrived" this field may have null if the patient did not come or a date and time value if it did come.

All I need is a query for a report that will give me the patient that have not come to the LAST 3 appointment!

As I have no friends that may help me in this situation I have try your forum.

But I see no way of doing so.

Sorry if my spelling is not correct!

Gracias

Roberto

Options: ReplyQuote


Subject
Written By
Posted
Can not workout how to do this!
April 26, 2005 06:50AM


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.