03 2024 档案

sql server 左链接为准 ，匹配不到，空填充
摘要：SELECT *,PR.OrderNo FROM TB_USER uOUTER APPLY ( SELECT TOP 1 R.id, R.OrderNo FROM tb_order ( NOLOCK ) R WHERE R.ID = u.ORDERID ORDER BY OutTime desc ) 阅读全文
posted @ 2024-03-14 11:28 cclon 阅读(27) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示