I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
----- Original Message -----
From: "BCC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 10:18 AM
Subject: IFNULL issues??
> Hi,
>
> Maybe someone could take a moment to explain this behavior?
>
> I am using IFNULL() in an order by statement to push null values to the
> end of a table for sorting.
>
> For example:
> mysql> select distinct s.some_pk as myid, queryid from data_table s,
> userdata.queryinfo q where s.some_pk=q.myid order by IFNULL(myid, 999);
>
> This works fine (let's ignore for the moment the possibility of null
> primary key values :) ).
>
> However, this does not work:
> mysql> select distinct s.some_pk as myid from data_table s,
> other_data_table where s.some_pk=232 order by IFNULL(myid, 999);
> ERROR 1054: Unknown column 'myid' in 'order clause'
>
> What gives? What is the difference for IFNULL between these two
> statements? My first thought was that IFNULL for some reason does not
> recognize
> aliases, but then the first statement works. Also, 'pkid' is not
> ambiguous.
>
> I don't get it. Am I missing the obvious?
>
> Anyone?
> Thanks,
> Bryan
---------------------------------------------------------------------
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
