JOIN NOW

Informatics Practices

What is the difference between ON and USING join-clauses ?

SQL Joins & Grouping

2 Likes

Answer

The difference between ON and USING sub-clauses of JOIN clause of SELECT is that ON clause requires a complete join-condition whereas USING clause requires just the name of a join field. USING subclause produces natural join whereas ON clause produces equi-join.

Answered By

1 Like

Related Questions