11-SQL Aliases

Un ALIAS es un apodo o nombre temporero dado a una tabla o columna. Usamos el keyword AS para especificar el apodo

SELECT column_name AS Apodo
FROM table_name;

SELECT column_name
FROM table_name AS Apodo;

Vamos a darles apodos:

SELECT CustomerID AS ID, CustomerName AS Customer
FROM Customers;

Apodos compuestos por espacios deben ir encapsulados con brackets o doble comilla:

SELECT CustomerName AS Customer, ContactName AS [Contact Person]
FROM Customers;

SELECT CustomerName,

Address + ', ' + PostalCode + ' ' + City + ', ' + Country AS Address
FROM Customers;

Esta consulta logró FUSIONAR 4 columnas dentro de una celda.

Observa el uso del simbolo SUMA para concatenar las columnas en una sola.

SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName
FROM Customers, Orders
En esta consulta FUSIONAMOS 2 tablas referenciando tabla.columna

SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName
FROM Customers, Orders
Podemos hacer lo mismo usando ALIASES... o sea, APODOS... veamos:

SELECT o.OrderID, o.OrderDate, c.CustomerName
FROM Customers AS c, Orders AS o

C = Customers

O = Orders

Fill in the Blanks

En esta columna debes dar apodo a la columna PostalCode como Pno

SELECT CustomerName,
Address,
PostalCode 

FROM Customers;

Fill in the Blanks

Dale apodo Consumers a esa tabla

SELECT *
FROM Customers 
;

Fill in the Blanks

SELECT CustomerName,

FROM Customers;

Escribe el código para concatenar las columnas Address - PostalCode y City

Fill in the Blanks

SELECT

Orders.OrderID, Orders.OrderDate, Customers.CustomerName

FROM Orders AS o, Customers AS c;

Escribe la alternativa a la 2da linea de codigo para reemplazar el ALIAS