How to query results where a column with 2 classifications has same value in another column in the same table?
Something like this:

select a.columna, a.email
from (select * from tablename where columna='A') a
join (select * from tablename where columna='B') b
on (a.columnB=b.ColumnB)