You can also save yourself some typing and improve query readability by creating aliases using the AS keyword. Simply follow a table name with AS and the alias to use.<\/p>\n\n\n\n
SELECT name,author,title from You can also use AS to rename a column (whether or not joining tables), like this:<\/p>\n\n\n\n SELECT name AS customer FROM customers ORDER BY customer;<\/strong><\/p>\n\n\n\n Aliases can be particularly useful when you have long queries that reference the same table names many times \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" You can also save yourself some typing and improve query readability by creating aliases using the AS keyword. Simply follow a table name with AS and the alias to use. SELECT name,author,title fromcustomers AS cust, classics AS class WHERE cust.isbn=class.isbn; You can also use AS to rename a column (whether or not joining tables), like … Continue reading Using AS<\/span>
customers AS cust, classics AS class WHERE cust.isbn=class.isbn;<\/strong><\/p>\n\n\n\n