SELECT Person.*, Gender.name
FROM Person INNER JOIN Gender ON Person.Gender = Gender.gender_id
WHERE (((Gender.name)="man"));