how to query and get the relation for Part with AML/AVL by SQL in database

[ML_7828431]

I am using Windchill PDMLink Release 11.0 and Datecode with CPS M030-CPS22

Through database query (SQL). How to query the AML/AVL association of the material number

how to get the relation(link) of the specific part with manufacturer and manufacture part (AML/AVL) in database by SQL
Is the relation (AML/AVL) a table in database ?

Translated by the Community Moderation using Google Translate 
-----------------------------------------------------------------------------------------------
透過資料庫查詢(SQL)。如何查詢料號AML/AVL 關聯

[Marco_Tosin]

If you search the Technical Support Knowledge Base, you will find plenty of articles explaining how to run queries in the Windchill database.

For the SuMa module, there is a summary article

https://www.ptc.com/en/support/article/CS385132

As well as a specific one that might be right for you.

https://www.ptc.com/en/support/article/CS40399

From the query builder reports you can also extract the related SQL query.

https://www.ptc.com/it/support/article/CS135285