 <p>An alternative solution might be to create a database view on table1, with a field called something like <code>title_Name</code> (defined as table1.Name for version #1, and as table1.title for version #2), and use the database view instead of table1 in your query, joined like so:</p> <pre><code>INNER JOIN table3 t3 on t1.title_Name = t3.Name </code></pre>