另外這張有問題，訂單有4個items, 但生產單只出二個，但物料清單就有4個 另外這張有問題，訂單有4個items, 但生產單只出二個，但物料清單就有4個sql problemROW_NUMBER()OVER(PARTITION BY sol.name ORDER BY sol.name) as RN0, --> ROW_NUMBER()OVER(PARTITION BY sol.id ORDER BY sol.id) as RN0, Was this article helpful? Yes | No