Ver originalSELECT * FROM tabla t WHERE t.campo1 IN (SELECT a.campo1 FROM tabla a WHERE a.campo2 = t.campo2)