On Thu, Feb 17, 2005 at 23:46:59 +0800, WeiShang <[EMAIL PROTECTED]> wrote: > 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?
If this isn't a made up example, you don't want to do this. You should use IN or OR to select records corresponding to the days of interest and then use ORDER BY to select the ordering. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
