title: SQL Server -- order by clause is dependent on (field-list, type) pair
body: <p>The query, say "Query-1": </p>
  
  <pre><code>select THIS_FIELD, THAT_FIELD, THAT_COUNT 
      from THE_TABLE 
      order by THIS_FIELD
  </code></pre>
  
  <p>is running fine when <code>THIS_FIELD</code> is of type <code>String</code>. however, "Query-2" below:</p>
  
  <pre><code>select THIS_FIELD, THAT_FIELD, THAT_COUNT, * 
      from THE_TABLE 
      order by THIS_FIELD
  </code></pre>
  
  <p>isGiving me an <code>Ambiguous column name</code> error to the occurrence of 
  <code>THIS_FIELD</code> in the select clause when 
  <code>THIS_FIELD</code> is of type <code>String</code>, and is running OK when <code>THIS_FIELD</code> here is an integer. </p>
  
  <p>How can i get around this? </p>
  
  <p>TIA. </p>