Is there a way to compare > = 2 columns in a IN
clause %? type as if it were to compare objects?
For example (It will give error so the question)
SELECT * FROM Usuarios1 WHERE Nome,Sobrenome IN(SELECT Nome,Sobrenome from Usuarios2);
or it would be something like
SELECT * FROM Usuarios1 WHERE Nome,Sobrenome IN(('Leo','Bonetti'),('José','Silva'));