New course! Every coder should learn Generative AI!
Try a free lesson0
Whats the differnce between ON and WHERE in join
4 Answers
+ 1
ืืื ื ืืกืืืื
If it is SQL see this
The ON clause defines the relationship between the tables. The WHERE clause describes which rows you are interested in. Many times you can swap them and still get the same result, however this is not always the case with a left outer join.
And one more suggestion
1. Use proper tags
+ 1
Thank you! Very helpfull
+ 1
ืืื ื ืืกืืืื welcome โบ๏ธ
0
Is it sql, please put proper tag