Keith Spiller wrote:
Hi Rolando,
Thanks for your help.
I have reduced the query to the bare essensials to try to test the
concept, but
it still fails...
( SELECT ID, Start, End
( SELECT ID, Start, End as z
FROM site_calendar_v2 as c
WHERE Global='1' )
UNION
( SELECT '99999', '2006-11-01', '0000-00-00' as z )
ORDER BY z, Start ASC, Status DESC, Time ASC a
Does anyone see my mistake?
Keith
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]