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  阅读(7)  评论(0)  编辑  收藏  举报