commlog

select t.lastcommdate
from
ticket t
where t.lastcommdate< (select max(logg.crdate)
from comlog logg
where t.ticketid=logg.ownerid
group by t.ticketid
);