Re: VIEW / ORDER BY + UNION

hi,

WeiShang wrote, On 2/17/2005 16:46:
> Hi, I have created a view like this :
>
> CREATE VIEW v1 AS (SELECT orderno,weekday,time FROM t1,t2 where
> t1.orderno=t2.orderno);
>
> if I create a SQL statment:
>
> (SELECT orderno FROM v1 WHERE weekday='MON' ORDER BY orderno)
> UNION
> (SELECT orderno FROM v1 WHERE weekday='WED' ORDER BY orderno)
> UNION
> (SELECT orderno FROM v1 WHERE weekday='FRI' ORDER BY orderno);
>
> Will the whole result will be sorted by the field orderno?

nothing says it will. you havet to sort the set of unions.
(select orderno ) union (select orderno ) order by orderno.

Not necessary now (no sense), to use order by in selects inside union.

C.