SELECT
  c.customerid,
  c.customer,
  am.accountmanager
FROM 
	Customers AS c 
INNER JOIN 
	AccountManagers as am 
USING (accountmanagerid)