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]声明：欢迎来到五六零学院。
查询报表：BOM子件查询父件
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]