Yep. In fact, if I replace 'myid' by s.some_pk the query works as well.
This is what make me think it was a feature (bug?) with IFNULL in that it
would not recognize aliases. But then theres the query that does work :P
Bryan
-----Original Message-----
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 10:45 AM
To: BCC; [EMAIL PROTECTED]
Subject: Re: IFNULL issues??
If you drop the order by, does the second query work?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
---------------------------------------------------------------------
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
