跳至主要內容

BOM子件查询父件

五六零网校小于 1 分钟

代码示例

SELECT T0.[Father] AS '主件编码', T0.[Code] AS '子件编码', T0.[Quantity], T0.[Warehouse]
FROM ITT1 T0
WHERE T0.[Code] LIKE '%%[%0]%%'
ORDER BY T0.[Father], T0.[Code]