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

 

原文地址:http://www.cnblogs.com/wzf-Learning/p/16852291.html

发表评论

您的电子邮箱地址不会被公开。