Vendor credit information number with vendor subgroup

I would like to extract vendor information but unable to get the combination between 2 tables as follows:

Vendor credit information number with vendor subgroup in Add Data.

My manager would like to see which vendor falls under which category and list of business.

Please help.

Cyndi