SELECT DISTINCT BOM.INVENTORY_ITEM_ID ID, ITEM.ITEM_NAME VALUE FROM msc_bom_components bom, msc_system_items item WHERE bom.inventory_item_id = item.inventory_item_id
View Text - HTML Formatted
SELECT DISTINCT BOM.INVENTORY_ITEM_ID ID , ITEM.ITEM_NAME VALUE FROM MSC_BOM_COMPONENTS BOM , MSC_SYSTEM_ITEMS ITEM WHERE BOM.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID