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]
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]