select Item_Number, Model_Number from RK_BOM GROUP BY Item_Number
Would return something ike
Item_Number_1, Model_Number1
Item_Number_1, Model_Number2
Item_Number_1, Model_Number3
Item_Number_2, Model_Number1
Item_Number_3, Model_Number1
Item_Number_3, Model_Number2
Item_Number_3...