Consulting

Results 1 to 4 of 4

Thread: How to union two tables without losing ordering

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    How to union two tables without losing ordering

    Hello I use this sql sheme
    TABLE (... ORDER BY ...)
    UNION
    TABLE (... ORDER BY ...)
    I have this two table
    1-14.6.2017 - - -
    1491219,95 1519 981,71 1
    4540487,32 4273 1062,6 2
    7793302,9 6484 1201,93 3
    2007632,09 2313 867,98 4
    3370946,87 2600 1296,52 5
    3458361,78 2735 1264,48 6
    and
    15-31.6.2017 - - -
    1912881,67 1819 1051,61 1
    4874438,49 4572 1066,15 2
    8925168,88 7427 1201,72 3
    2318450,72 2736 847,39 4
    3759952,25 2949 1274,99 5
    1766691,22 1376 1283,93 6

    but i get
    1-14.6.2017 - - -
    1491219,95 1519 981,71 1
    15-31.6.2017 - - -
    1766691,22 1376 1283,93 6
    1912881,67 1819 1051,61 1
    2007632,09 2313 867,98 4
    2318450,72 2736 847,39 4
    3370946,87 2600 1296,52 5
    3458361,78 2735 1264,48 6
    3759952,25 2949 1274,99 5
    4540487,32 4273 1062,6 2
    4874438,49 4572 1066,15 2
    7793302,9 6484 1201,93 3
    8925168,88 7427 1201,72 3
    How to just join two tables without losing ordering?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •