incidentally i'd like to post this great mysql tutorial resource, its got live examples to help you understand stuff.

JOIN tutorial:
http://sqlzoo.net/3b.htm

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)