title: Select on 2 tables that contain same field name?
body: <p>I am developing a CMS that using database based on Joomla ! In Joomla db, we have 2 table :</p>
  
  <pre><code>+----------+
  |Categories|
  +----------+
  id
  title
  ...
  
  +-------+
  |Content|
  +-------+
  id
  title
  catid
  ...
  </code></pre>
  
  <p>I have a query below :</p>
  
  <pre><code>SqlQuery q = new Select("*")
                           //.Top("1")
                           .From(JosContent.Schema)
                           .InnerJoin(JosUser.IdColumn, JosContent.CreatedByColumn)
                           .InnerJoin(JosCategory.IdColumn, JosContent.CatidColumn)
                           .Where("catid").IsEqualTo(catId);
  </code></pre>
  
  <p>And in the ASPX page, I show data like that :</p>
  
  <pre><code>Tite : &lt;%# DataBinder.Eval(Container.DataItem, "title") %&gt;
  In category : &lt;%# DataBinder.Eval(Container.DataItem, "title") %&gt; 
  // Category tite not Content title, but ASP.NET think it is Content title :-(
  </code></pre>
  
  <p>Please help me fix it ? How to discean between that ? </p>
  
  <p>Thanks alot !</p>