where clause using alias with sub select clause

SELECT FullName FROM
(
SELECT
FullName = LastName + ‘, ‘ + FirstName
FROM Employees
) sub
WHERE sub.FullName = ‘Bertrand, Aaron’

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.