INSERT INTO Food (FoodID, FoodName, ItemID, ItemName) Select DISTINCT FoodID, FoodName, ItemID, ItemName from Food f CROSS JOIN Item i