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