title: Is it possible to rename a joined column during an inner join?
body: <p>Say I have two tables, <code>owner</code> and <code>dog</code>. Both have column <code>name</code>, but I'd like to join them, so there is a problem since both tables have column <code>name</code>. Can I rename (alias) the <code>name</code> column in the dog table during the query?</p>