SQL query to extract Family table generic and instance in windchill

[GD_9887860]

Looking for query to extract the Family table data from database

need query to join family table generic with its instance 

Using Windchill 12.0

[Marco_Tosin]

You can search the knowledge base here

This is an article that can help you

Report/SQL Query to get CAD Generic Part and its corresponding Instance parts