SqlServer outer apply(cross apply)

select *  from baiduacg_cookies c cross apply (select top 1 * from product where AccountId=c.AccountId order by CreateTime desc)t