Just want to make sure this is correct.

SELECT R1 AS Row FROM T1
UNION
SELECT R2 AS Row FROM T2
UNION
SELECT R3 AS Row FROM T3

It appears the results are in reverse order. IE:
Row (from R3)
Row (from R2)
Row (from R1)
Is this how a UNION is supposed to work?

Thanks

Steve Fogelson
Internet Commerce Solutions
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to