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 .....

Answer 2

us the AS keyword

select a.Price as PriceOne, b.price as PriceTwo 
from tablea a, tableb b

Answer 3

select t1.Column as Price, t2.Column as Other_Price
from table1 as t1 INNER JOIN table2 as t2 
ON t1.Key = t2.Key

like this ?

Answer 4

if you are using sql server, use brackets or single quotes around alias name in a query you have in code.