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

Reply via email to