From a custom function (@ bom)
Key parameters by querying a custom function, bom, get all the bom level results as follows, the same different bomid itmid
How to keep the custom function queries the same, increases the final summary column sumqty (not by adding a custom function group query), and through the main table itmid, outer join other table, obtain otherqty
(whether to need to use separate bom list, bomID, itmid, qty related fields)
The select a. omid, Anderson tmid, a.q ty, sumqty, b.o therqty
From a custom function (bom) @ a
Left the join othertable on b on Anderson tmid=b.i tmid
