Probably a simple error here, been a few years since i last did SQL work...
I've got 2 tables (actually just one aliased
nevermind just typing this much allowed me to figure it out :) Love the
way you can spend a whole day trying to figure something out, and then
as soon as you try to explain the problem you figure it out :) reducing
expression on the right table needs to be in the join clause and not the
where :)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php