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
How is a cross join different from natural join ?
Can you join two tables without using the keyword JOIN ?
A table STUDENT has 4 rows and 2 columns and another table TEACHER has 3 rows and 4 columns. How many rows and columns will be there if we obtain the Cartesian product of these two tables ?
What does UNION do ?