Código SQL [-] SELECT A.* FROM TABLA_A A WHERE (A.CAMPO1||A.CAMPO2) IN (SELECT B.CAMPO1||B.CAMPO2 FROM TABLA_B B WHERE B.CAMPO3 = 10)
SELECT A.* FROM TABLA_A A WHERE (A.CAMPO1||A.CAMPO2) IN (SELECT B.CAMPO1||B.CAMPO2 FROM TABLA_B B WHERE B.CAMPO3 = 10)