LISTING 3: Code That Creates an Alias for a Table Variable

DECLARE @MyCustomers TABLE (CustomerId char(10))
INSERT INTO @MyCustomers SELECT CustomerId FROM customers WHERE country = 
'Mexico'

SELECT
	Customers.*
FROM
	Customers INNER JOIN @MyCustomers MyCust
		ON Customers.CustomerId = MyCust.CustomerId