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

Code:
SELECT *, name, email FROM equipment 
LEFT JOIN users ON equipment.owner = users.id
I've tried to use aliases but have had no success.

thanks