I suggest you ...

BUG: columns displayed in different order than selected??

SELECT name = ISNULL(s1.name, s2.NAME), r1 = s1.rows, r2 = s2.rows, diff = s2.rows - s1.rows
FULL OUTER JOIN

will show name, r2, r1, diff in the result grid
instead of name, r1, r2, diff

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Traci Dennis shared this idea  ·   ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Traci Dennis commented  · 

        Even stranger: changing the column order then shows the columns in the right order. In other words, nothing I do to the SELECT statement will force the columns to appear in the order I want them to.
        -- switch the column order
        SELECT name = ISNULL(s1.name, s2.NAME), r2 = s2.rows, r1 = s1.rows, diff = s2.rows - s1.rows
        FULL OUTER JOIN

        still shows name, r2, r1, diff in the result grid

      Feedback and Knowledge Base