Home / Table Joins / Question No: 128

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.