Expanding Bill of materials to get full product list

Hi all, I have 3 table,  Table 1 - Product master  Item Type Item List Item Code Item Mouse MS001 Item KeyBoard MS002 Item Laptop MS003 Item Notebook MS004 Item Pen M...