Code:SELECT p.name, a.name FROM (SELECT client_id, admin_id FROM penalties WHERE ...[your where clause goes here if any]) b INNER JOIN (SELECT name, id FROM clients) a ON (a.id = b.admin_id) INNER JOIN (SELECT name, id FROM clients) p ON b.client_id = p.id