title: The column name is not valid - error
body: <p>I am getting this error while I am fetching value from resultset.  </p>
  
  <blockquote>
    <p>Error : com.microsoft.sqlserver.jdbc.SQLServerException: The column name company.short_name is not valid</p>
  </blockquote>
  
  <p>CASE 1 :</p>
  
  <pre><code>select company.short_Name,location_name from company,location;
  </code></pre>
  
  <p>this query is executing fine on SQL Server but in my java code when I trying to retrieve value like <code>resultset.getString("company.short_name");</code> that time this give the above error.</p>
  
  <p>CASE 2 :</p>
  
  <pre><code>select company.short_Name short_name,location_name from company,location;
  </code></pre>
  
  <p>and retrieve value like <code>resultset.getString("short_name");</code> than it work fine with both database MySQL and MSSQL.</p>
  
  <p>I am migrating my database from MySQL to MSSQL.above case 1 is work fine in MySQL, but why it is not work in MSSQL?</p>