SELECT 
  agent.name as 'Agent',
  specialty.name as 'Specialty'
FROM
  agent, specialty, agent_specialty
WHERE
   agent.agentID = agent_specialty.agentID
AND
  specialty.specialtyID = agent_specialty.specialtyID;