is there any difference between "on" and "using" in sql-joins? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 6

is there any difference between "on" and "using" in sql-joins?

Or do they both just name the connecting column? Thx!

20th Nov 2018, 11:26 AM
SouthPoleHillbilly
SouthPoleHillbilly - avatar
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.
20th Nov 2018, 2:29 PM
Prokopios Poulimenos
Prokopios Poulimenos - avatar
+ 4
that makes sense if I look into the course documents:) thx👍
20th Nov 2018, 3:26 PM
SouthPoleHillbilly
SouthPoleHillbilly - avatar