Posted onFebruary 9, 2011 by Josephine where clause using alias with sub select clause SELECT FullName FROM ( SELECT FullName = LastName + ‘, ‘ + FirstName FROM Employees ) sub WHERE sub.FullName = ‘Bertrand, Aaron’