SQL End-Item Query?

Does anyone have a SQL query for Vantage that will return the
end-items (manufactured parts) that a given purchased part?



I've written a query that explodes a BOM from the top, but I want to
go the other way around and generate a 'where used' list of parts from a
given purchased part.



-brian



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]