Access: Requête avec dernier enregistrement d'une table en lien avec une autre

select t1.nom, t1.prénom, t2.max_date from table1 as t1
join (select id, max(date) as max_date from table2 group by id) as t2
   on t1.id = t2.id

select t1.nom, t1.prénom, t2.max_date 
from table1 as t1, (select id, max(date) as max_date from table2 group by id) as t2
where t1.id = t2.id 

select t1.nom, t1.prénom, max(t2.date) as max_date
from table1 as t1, table2 as t2
where t1.id = t2.id
group by t1.nom, t1.prénom

SLECT t1.id, t1.nom,t1.prénom,t2.date
FROM t1 LEFT JOIN t2 ON t1.[id] = t2.[id]
WHERE (((t2.[Date])=(select max(t2.[Date]) from t2 where t1.[id] = t2.[id])))

select t2a.*
from table2 as t2a, (select id, max(date) as max_date from table2 group by id) as t2b
where t2a.id = t2b.id and t2a.date=t2b.max_date

Discussions similaires