A shortcut notation to join tables based on two (or more) columns

select *
from t1
  join t2 on (t1.a, t1.b) = (t2.a, t2.b);

is equivalent to

select *
from t1
  join t2 on t1.a = t2.a and t1.b = t2.b;

Back to the SQL Feature Comparison