Started 2 weeks, 2 days ago (2009-12-01 08:09:00)
by jay.uh
Hi, I have the answer for this problem :
SELECT
gdl.id_dp_log, gdl.date , gdl.heure ,gdl.source_consigne ,gdl.id_redacteur ,gdl.id_valideur ,
gdl.id_dp , gdl.id_etat
FROM
gdp_dp_log gdl
INNER JOIN ( SELECT max(concat(date, ' ', heure)) AS max_dtime, id_dp
FROM gdp_dp_log
GROUP BY id_dp ) mdt
ON mdt.max_dtime = ...
Thread:
Show this thread (3 posts)
Size: 573 bytes
Related Threads: Same Site | All Sites
Customize:
Related Threads: Same Site | All Sites
Customize:

