SQL Syntax error

[Robbinski12]

Hallo allemaal,

Kan iemand mij helpen met mijn query??
[SQL]SELECT * FROM `users` WHERE `username`='1' AND `password`='2' INNER JOIN `sites` ON `sites`.`id`=`users`.`siteid`[/SQL]

Dit is de error: "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN `sites` ON `sites`.`id`=`users`.`siteid` LIMIT 0, 30' at line 1"

Alvast bedankt!
Robin

 

[Epic]

De volgorde klopt niet, 'inner join' moet direct na de 'from':[sql]SELECT * FROM `users` INNER JOIN `sites` ON `sites`.`id`=`users`.`siteid` WHERE `username`='1' AND `password`='2'[/sql]

 

[Robbinski12]

Oow ja... ff vergeten

Dank je
Robin