[thelist] SQL Union and order by problem

[Tab Alleman]

But pursuing Rudy's idea, you could make an ordering column that uses the DATEDIFF and its inverse.  But he's probably right; whatever you're trying to do might better be done without a UNION at all.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of r937
> Sent: Thursday, October 18, 2007 2:30 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] SQL Union and order by problem
> 
> 
> >  you could have a column with the value -b in the first SELECT...
> 
> uh, wait a sec...   b appears to be a date
> 
> i would suggest you take another look, or explain what you're 
> doing, because 
> right now i don't think you need a UNION at all
> 
> ;o)
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
>