Assistance with part of a join
SELECT C.Name_of_customer,
       C.[Customer/VendorID],
       E.Employee_Name, 
       E.EmployeeID 
from Order_Information_local as O
JOIN Employee_Info_local as E
JOIN [Customer/Vendor_Info_local] as C
       ON C.[Customer/VendorID] = O.[Cusrtomer/VendorID]) 
      AND E.EmployeeID = O.EmployeeID;