Databinding Table References
<p>I have two tables tblCarrier and <code>tblCustomer</code>. Both tables are <code>INNER JOIN</code> and have the same column name which is company name. The problem is when I use the databinding process </p>

<p><code>&lt;%#DataBinder.Eval(Container.DataItem, "CompanyName")%&gt;</code>  to get the back the customer company name, it gives me back the carrier company name. What I notice from my query is that it gets back the company name based on the order sequence in the query statement.</p>

<p>For example</p>

<blockquote>
  <p>"SELECT
  tblCarrier.CarrierID,tblLoadMaster.Salesperson,tblLoadMaster.Status,
  tblCarrier.CompanyName, tblCustomer.CompanyName"</p>
</blockquote>

<p>This T-SQL statement will bring back the carrier company name, but if I were to put the <code>tblCustomer.CompanyName</code> before <code>tblCarrier.CompanyName</code>, it will then bring back the  customer company.</p>

<p>Is there way to databind the columns to get the results based on the cross reference table?</p>
