SELECT
i.*, p.`plec`
FROM
`imie` i
JOIN
`plec` p ON i.idplec = p.`idplec` and p.`plec` = 'kobieta'
SELECT
i.*, p.`plec`
FROM
`imie` i
JOIN
`plec` p ON i.idplec = p.`idplec` and p.`plec` = 'kobieta'