> If you do Union them, does that still allow you to 'order by' the sub
queries
no
a query that includes a UNION is called a "fullselect" and its components
are called "subselects"
the subselects are not allowed to have an ORDER BY, only the fullselect
sometimes you will see this --
select foo from sometable
union
select bar from someothertable
order by 1
but be aware that the ORDER BY here applies to the fullselect, and it is the
combined entire result set that is sorted, and not the last subselect
> I definitely don't get Rudy's example below. Sorry to be so thick.
hey, man, don't fret
just try it and see what you get
ask questions if it doesn't work or you don't understand
that's why we're here
;o)
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
