KnowledgeBoat Logo

Informatics Practices

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

SQL Joins & Grouping

3 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

3 Likes


Related Questions