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
The single value is just used to illustrate the structure of the query.
I had originally tried using IFNULL as you suggested, but it sorts the table
differently than if it is used in the order by. For example, if I have NULL
values (as a result of a left outer join), they will always appear at the
beginning of my table. Using desc is not an option here. Using IFNULL as
you suggest replaces the NULL values properly, but they still stay at the
beginning of the table. Looks wierd when your table is ordered as: 999,
999, 999, 1, 2, 3, 4. :) Using IFNULL in the order by fixes this.
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
