SQL Statement -populating supplier information

I need help with an SQL statement that will populate a specific supplier to different items, based on the item department or category. Thanks in advance.

snipped-for-privacy@gmail.com