Shaan

Shaan

  • 1.9k
  • 110
  • 7.5k

"Ambiguous column name 'Id'"

Aug 28 2022 3:41 AM

Hi everyone.
Doesn't it work with order by alias bound to the parameter?

My order by:

ORDER BY CASE
             WHEN @ordercolumn = 'Id' THEN Id
             WHEN @ordercolumn = 'Username' THEN Username
             END

I get error "Ambiguous column name 'Id'"

My select:

SELECT DISTINCT P.Id,
                P.Username     Username,
                                   ………

I can't post the whole code because it's 150 lines but there are no other Id columns in the selection


Answers (3)