Re: join with OR and LIMIT fails to return result

2002-11-26 Thread Jocelyn Fournier
ws. " http://www.mysql.com/doc/en/News-4.0.5.html Regards, Jocelyn - Original Message - From: "John Ragan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Bill Marrs" <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 9:37 PM Subject: Re: join with OR and L

Re: join with OR and LIMIT fails to return result

2002-11-26 Thread John Ragan
nload corereader. it will let you quickly experiment with point-and-click queries to debug query logic.http://corereader.com > >Description: > join with OR and LIMIT fails to return result > >How-To-Repeat: > > This query fails to return a result: > >

join with OR and LIMIT fails to return result

2002-11-26 Thread Bill Marrs
>Description: join with OR and LIMIT fails to return result >How-To-Repeat: This query fails to return a result: mysql> SELECT Subscriptions.UID FROM Subscriptions, Accounts WHERE Accounts.UID = Subscriptions.User AND (Accounts.Email = 'bill' OR Accounts.UName