What is the advantage (or advantages) of using JOIN instead of WHERE in a SELECT statement?
Is JOIN faster than WHERE?
I have a SELECT statement that involves 7 tables and I am using WHERE to relate them and get the result I need but I want to know if there is a performance issue if I change to JOIN.