This query may useful

Select a.* from a

inner join b

on (a.id = b.id and b.age >30)

where a.sex = 'M'

Bye