+ 6
is there any difference between "on" and "using" in sql-joins?
Or do they both just name the connecting column? Thx!
2 Answers
+ 7
USING is for the situation where the column names which are join keys are the same.
On is for both situations column names which are join keys are the same or different.
-----------------
If your question is related with the performance, there is no difference.
+ 4
that makes sense if I look into the course documents:) thxđ