I have 1 relation A.
Structure of A: NoPeople Date_entry Date_departure
and key is (NoPeople + Date_entry)
exemple of records:
NoPeople Entry Departure P1 E1 D1 P1 E2 D2 P1 E3 NULL
P2 E1 NULL
P3 E1 D1
P4 E1 NULL P4 E2 NULL P4 E3 D2
E3>E2>E1 and D2>D1. P1,P2,P3 and P4 are different persons.
I would like to query all the people whose date_entry is their MAX date entry AND that have their date departure to NULL. In this exemple, P1 and P2 are ok. P4 isn't ok because max(Date_entry) is E3 and Date_departure - when Date_entry is E3 - isn't NULL.
I tried some queries with 'group by' but i can't make it working. Any hint "sql masters" :)
fab
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]