If you use MySQL workbench, you might or already have encountered an error such as “Select is not valid at this position for this server version”.
Suppose there are two tables customers and orders between which we want to apply a JOIN operation on columns
customeridof tables customers and orders respectively.
SQL Query for the JOIN operation should be
SELECT * FROM customers JOIN orders ON customers.id = orders.customerid;
Now if you mistakenly place the ON keyword just after JOIN keyword and insert a WHERE before the condition, which makes the query as
SELECT * FROM customers JOIN ON orders WHERE customers.id = orders.customerid;
Thus, if you encounter this error next time, do check the syntax of your SQL query before searching any further.
Do not forget to hit the clap button.