mysql - Is it possible to rename a joined column during an inner join?

Question

Say I have two tables, owner and dog. Both have column name, but I'd like to join them, so there is a problem since both tables have column name. Can I rename (alias) the name column in the dog table during the query?

question from:https://stackoverflow.com/questions/5994485/is-it-possible-to-rename-a-joined-column-during-an-inner-join

Answer 1

select d.Name as DogName, o.Name
from Dog d
inner join Owner o on d.OwnerID = o.OwnerID