22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT e.* ,
b.ProductName
FROM Tbj_IntegralChange e
LEFT JOIN Tbj_Member a ON e.MemberId = a.Id
OUTER APPLY( SELECT TOP 1
r.ProductName
FROM tb_barcodeout q
LEFT JOIN tb_productbatchNo w ON q.batchid = w.id
LEFT JOIN tb_product r ON w.product = r.id
WHERE q.fwcode = e.jfcode
AND e.jfcode != ''
) AS b
ORDER BY ChangeId DESC;