SELECT colonne1 [AS c1],
       colonne2 [AS c2]
FROM table1 [AS t1] JOIN table2 [AS t2] ON t1.clea = t2.cleb
AND t1.cleb = t2.cleb;