Harals: Any resultset which ANDs any/all condition(s) would further restrict that resultset to meet the criteria I guess I just dont understand your definition of 'complaining' Martin- ----- Original Message ----- From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 14, 2004 8:41 AM Subject: Re: Q: outer join w/restriction
> 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]