What's the difference between “using” and “on” in table joins?

... T1 join T2 using(ID) where T2.VALUE=42 ...

... T1 join T2 on(T1.ID=T2.ID) where T2.VALUE=42 ...

... T1 join T2 on(T1.ID=T2.ID and T2.VALUE=42) ...

T1 JOIN T2 USING(id) JOIN T3 USING(id_2)

T1 JOIN T2 ON(T1.id=T2.id) JOIN T3 ON(T1.id_2=T3.id_2 AND T2.id_2=T3.id_2)

T1 JOIN T2 ON(T1.id=T2.id) JOIN T3 ON(T2.id_2=T3.id_2)

SELECT T1.ID, T2.ID, T2.VALUE FROM T1 LEFT OUTER JOIN T2 ON(T1.ID=T2.ID) WHERE T2.VALUE=42

SELECT T1.ID, T2.ID, T2.VALUE FROM T1 LEFT OUTER JOIN T2 ON(T1.ID=T2.ID AND T2.VALUE=42)

1, NULL, NULL

A JOIN B USING (column1)

A JOIN B ON A.column1=B.column1

A JOIN B USING (column1, column2)

A JOIN B ON A.column1=B.column1 AND A.column2=B.column2