Help with multiple joins

I have two tables, equipment and users. In the equipment table I have two field, owner and technician which both link to the users table id.

I can get the owner’s name using a single join, but not sure how to get the technician’s name

SELECT *, name, email FROM equipment 
LEFT JOIN users ON equipment.owner =

I’ve tried to use aliases but have had no success.


Need to see the tables’ detaisl

SELECT equipment.*
     , AS owner_name
     , AS owner_email
     , AS technician_name
     , AS technician_email
  FROM equipment 
  JOIN users AS owner
    ON = equipment.owner 
  JOIN users AS technician
    ON = equipment.technician 


Thanks r937.