How can I rename a single column in a table at select?

Question

I have two tables with one identical column name, but different data. I want to join the tables, but access both columns (row["price"], row["other_price"]): How can I rename/alias one of them in the select statement? (I do not want to rename them in the DB)

Answer 1

select table1.price, table2.price as other_price .....