I have two tables:
Pessoa1 Pessoa2 +----+--------+ +----+--------+ | Id | Nome | | Id | Nome | +----+--------+ +----+--------+ | 1 | Maria | | 3 | Maria | | 2 | João | | 4 | João | +----+--------+ | 5 | Pedro | +----+--------+
I would like to get the names that appear in both tables.
Resultado +--------+ | Nome | +--------+ | Maria | | João | +--------+