Help! View that joins company and person

Hi Everyone,

I am trying to customize a view that can look up customer number from the entity company and match it with each person associated with that company. The fields that I would like in the view are customer number, company name, business email, licence type, first name, last name and title.

I tried to use inner join and left join but they all seem to retrieve an error. Any help is highly appreciated!