Union clause

[Sushant Choudhary]

Hi All,

i have question regarding Union clause.

does mysql offer guarantees on the order of the results from a UNION query?

example:

`select col1 from table1 union select col2 from table2;`

if above is my query. does result will contain the data from table1 followed by result from table2.

if table1 has data for 1, 4 . and table2 has data 2, 3

the result will be 1, 4, 2, 3 or 2, 3, 1, 4 ??