mysql to select all from one table inner join with another table on some condition fails [closed]

Question

SELECT a.* FROM works AS a WHERE a.userid=15 INNER JOIN users AS b ON a.userid=b.id;

Something is just wrong and I don't know why, someone could offer some help please ? Thank you

Answer 1

Your WHERE clause is in the wrong position. It always follows all tables listed and joined in the FROM clause.

SELECT a.* 
FROM
   works AS a
   INNER JOIN users AS b ON a.userid=b.id
WHERE a.userid=15 ;