Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 59 of 91

JOINS and SET Operations — Question 10

Back to all questions
10
Question

Question 10

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

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.