How would you write this MSSQL statement in MySql?

[joezen777]

select a.id , (select top 1 value from tbl2 where tbl2.id = a.id order by tbl2.date desc) from tbl1 a

Thanks