SELECT distinct i.plan_id, i.inventory_item_id, i.item_name from msc_system_items i, msc_supplies s WHERE i.plan_id = s.plan_id and i.inventory_item_id = s.inventory_item_id
View Text - HTML Formatted
SELECT DISTINCT I.PLAN_ID , I.INVENTORY_ITEM_ID , I.ITEM_NAME FROM MSC_SYSTEM_ITEMS I , MSC_SUPPLIES S WHERE I.PLAN_ID = S.PLAN_ID AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID