how about this ::

Select * from table1 A(nolock)

left join (select logid,max(timestamp) as Ttime from table2(nolock) group by logid ) B

on A.logid=B.logid