laika222
10/27/2016 - 7:53 PM

You have the ability to change the column names in the output by using AS. In Line1, values are pulled from the Price column of the Orders2

You have the ability to change the column names in the output by using AS. In Line1, values are pulled from the Price column of the Orders2 table, but the column is renamed AS 'Suggested Retail Price' in the output. This doesn't change the table.

SELECT AS SS & MS.sql
content_copyfile_download
SELECT Price AS 'Suggested Retail Price'
FROM Orders2;