Difference between INNER JOIN and WHERE Clause

[soso_online]

i have been trying to find out what is the difference between INNER JOIN and WHERE CLAUSE. Any one with help please

Back off i am coding

[GuyThiebaut]

Joins - clickety Where - clickety

You always pass failure on the way to success.

[Joe DiNatale]

No real difference. You can express your inner joins in the WHERE clause if you wish (I believe in the early versions of SQL you had to), but your code will be easier to understand if you separate join conditions from the other conditions.