Problem with join

[eluser]überfuzz[/eluser]
[quote author="Sein Kraft" date="1260045300"]error:

Unknown column 'roles.id' in 'on clause'

SELECT * FROM (`users`) JOIN `roles` as id_roles ON `roles`.`id` = `users`.`role` JOIN `ranks` as id_ranks ON `ranks`.`id` = `users`.`rank` LIMIT 1

[/quote]

Well John Betong assumed that you actually had a table called roles with a column called id. Could you show us your tables? Not type how to go about creating them.