MySQL Forums
Forum List  »  General

Re: how use a TIMESTAMP and compare it with a MAX of another TIMESTAMP
Posted by: Roberto B.
Date: April 09, 2014 02:29PM

hi Peter,

select a.*
from table1 a
join (
select name, max(timestamp(tickdate,ticktime)) as timemax
from table2
group by name
) AS x on a.name=x.name and timestamp(a.giorno,a.orario) > x.timemax;

seems working perfectly.
Really thanks: i was in a deadlock
Roberto

Options: ReplyQuote


Subject
Written By
Posted
Re: how use a TIMESTAMP and compare it with a MAX of another TIMESTAMP
April 09, 2014 02:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.