Hi All,
I am very new in Mysql. Please Help me.

Following two select queries:-
1) Will give me Max response time value but date and time not coming as per the Max value.

select l.name,d.datetime,MAX(d.value) from performance_labels l,performance_data d where l.id=d.performance_label and d.performance_label='134' and d.datetime >'2008-12-22 01:00:00' and d.datetime < '2008-12-22 02:00:00' Group by l.name;

2) Will give me the Response time value for one hours.

select l.name,d.datetime,d.value from performance_labels l,performance_data d where l.id=d.performance_label and d.performance_label='134' and d.datetime >'2008-12-22 01:00:00' and d.datetime < '2008-12-22 02:00:00'


Required one query which give me the correct date and time as per the Max value.

Thanks,
Kalpesh