Execute the following SQL Server T-SQL script in Management Studio Query Editor to demonstrate phone list builder SQL query.

-- SQL inner join - SQL string concatenation
USE AdventureWorks;
SELECT   Employee = c.FirstName + ' ' + c.LastName,
         c.Phone
FROM     AdventureWorks.HumanResources.Employee e
         INNER JOIN AdventureWorks.Person.Contact c
           ON e.ContactID = c.ContactID
ORDER BY Employee ASC
GO
/* Partial results
 
Employee                Phone
A. Scott Wright         992-555-0194
Alan Brewer             438-555-0172
Alejandro McGuel        668-555-0130
Alex Nayberg            819-555-0198
Alice Ciccu             333-555-0173
Amy Alberts             775-555-0164
*/