(One more time, i'm sorry for the bad english ... I'm french and my english teacher were bad -__-')
So, my problem is : I've created a board to see state of any bug.
Exemple :
ID_Bug , State
1, New
2, Affected
3, Corrected
...
But, if a state was 'New', and then 'Affect', i would like to get the last State of this bug (here : 'Affect').
In my database, i had a table BugActif (ID_Bug, State, ID_DATE) which, for each ID_DATE, contains ID_Bug and his state for this date.
In fact, i would like to get the state of all bug for the max(ID_DATE).
Regrettably, my only idea is to do a set analysis like : "{<ID_DATE={"$(=max(ID_DATE)"}>} State" but without an aggregate fonction, this one cannot work...
