In the JOIN clause you can go for: t1 JOIN t2 ON t1.c1 = t2.c1 or t1 JOIN t2 USING ( c1 ) The key difference is USING de-duplicates the join columns in the results when you use SELECT * @vlad_mihalcea explains vladmihalcea.com/sql-join-using/ #SQL