34,590
社区成员
发帖
与我相关
我的任务
分享
select b.* , (select top 1 SupplierCode from a where OrderNO = b.OrderNO order by OrderDate) from b
select b.* , (select top 1 SupplierCode from a where OrderNO = b.OrderNO order by OrderDate desc) from b
select *,
(select top 1 SupplierCode from A where OrderNO=t.OrderNO order by OrderDate desc) as SupplierCode
from B t
SELECT B.*,A.* FROM B LEFT JOIN A ON B.ORDERNO=A.ORDERNO
?