Post reply

Column alias in order by working in sql server 2008R2 but intermittently

  • April 13, 2018 at 2:05 am

    #1986707

    "Component" is just an alias.  It's not a column of table b (VndrCmpntNum ).  Remove the "b." from the ORDER BY clause and it should work.

    John

  • April 14, 2018 at 4:49 pm

    #1986855

    Use 
    --------
    ORDER BY b.CmpntNum Or

    ORDER BY Component

    =======================================================================

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply