On 15/01/05 00:23 -0500, Ophir Prusak wrote: > Both queries have the same where clause. That's what I missed. I too would have expected the parser to execute the WHERE clause before the SELECT clause. Is this another case where MySQL is nonstandard? -- Regards, Faber Linux New Jersey: Open Source Solutions for New Jersey http://www.linuxnj.com