Actually this might be simple SQL Query related issue. I am displaying couple of
records in a webpart in a coloum using Select UNION Query. Like:

Tender NO
-------------------------
23
26
30

For the above I have used three select queires using UNION. My problem is I was
to display records exactly as it is stored physically on the DB Tables and not
ascending or Decending order


Tender No
----------------
30
23
26

Any help will be hightly appreciated. What would be the approprate query for the
same.