LISTING 2: Code That Tries to Use Table Variables in a Join

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

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