left join error

[AN-net]

what did i do wrong now>_<

Originally Posted by mysql

Invalid SQL: SELECT * FROM affiliates WHERE active='1' LEFT JOIN affiliates_types ON affiliates.type=affiliates_types.id ORDER BY sitename ASC
mysql error: 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 'LEFT JOIN affiliates_types ON affiliates.type=affiliates_types.