In article <[EMAIL PROTECTED]>, "Martin Gainty" <[EMAIL PROTECTED]> writes:
> "You should generally not have any conditions in the ON part that are used to > restrict which rows you want in the result set, but rather specify these conditions > in the WHERE clause" > Forgive me for following the documentation!! You didn't, actually. You did put the "ReviewerID = 2" clause into the WHERE clause and then complained that this restricted your result set ;-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]