Réponse acceptée !
voici la solution
incroyable mais ca marche
quelqu'un a t'il une idee du fonctionnement ?
j'ai pas compris la table cree dans la partie "from"
select distinct u.[user_id], u.user_n,a.action_id,a.action_rmk,
a.date_actioned,i.incident_id,i.incident_rmk
from [action] a,incident i, [user] u,
(select u.[user_id], u.user_n,max(a.date_actioned) date_actioned
from [action] a,[user] u
where a.[user_id] = u.[user_id]
group by u.[user_id], u.user_n) tbl
where u.[user_id] = tbl.[user_id]
and u.user_n = tbl.user_n
and a.date_actioned = tbl.date_actioned
and u.[user_id] = a.[user_id]
and a.incident_id = i.incident_id
ouais man