I am learning database query basics. I could not understand ON Clause clearly. Can I know what is difference between ON Clause and WHERE Clause?
There is little difference between them. The ON Clause works just like a WHERE Clause but the ON Clause is specific to a JOIN condition. If you need to, you can add extra conditions to the ON Clause using AND, just as you can with WHERE Clause.