in parentheses, MySQL will let you do what you want:
*******
(SELECT *
FROM Table1
WHERE Table1Item = 'something'
ORDER By SomeTableColumn
)
UNION
(SELECT *
FROM Table2
WHERE Table2Item = 'something'
ORDER By SomeTableColumn
)
********
If that doesn't work, add a constant field to your queries like this, which
will let you use the global ORDER BY
*******
SELECT 0 AS orderer, *
FROM Table1
WHERE Table1Item = 'something'
UNION
SELECT 1 AS orderer, *
FROM Table2
WHERE Table2Item = 'something'
ORDER By orderer, SomeTableColumn
********
Cheers,
barneyb
> -----Original Message-----
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 09, 2004 8:56 AM
> To: CF-Talk
> Subject: union and sorting
>
> Hi all,
> SQL Server question. I have a query like so:
> *******
> SELECT *
> FROM Table1
> WHERE Table1Item = 'something'
>
> UNION
>
> SELECT *
> FROM Table2
> WHERE Table2Item = 'something'
>
> ********
>
> SQL Server does not allow me to put in individual 'ORDER BY'
> statements on
> the individual selects.
>
> *******
> SELECT *
> FROM Table1
> WHERE Table1Item = 'something'
> ORDER By SomeTableColumn
>
> UNION
>
> SELECT *
> FROM Table2
> WHERE Table2Item = 'something'
> ORDER By SomeTableColumn
>
> ********
>
> Instead I can only put an 'ORDER BY' statement at the end of all the
> unions. I can't have that. I need to be able to show the
> results from the
> first select first, then the results from the second select.
>
> Any soultions?
>
> Thanks,
> George
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
