(Solution Document) I cannot figure out how to join tow select statments to get one out put with all

Please help quickly I need to create the following query in sql to create a report. I cannot figure out how to join tow select statments to get one out put with all the colums I need.

This is the request -Human Resources has requested a listing of employees. They want the listing to show the first initial of the employee's last name. In addition, they want the report in the following sort order: exempt/non-exempt status, the first letter of their last name, last name, first name and salary. For example: Exempt, S, Smith, Bob, $50,000

here is what I wrote- SELECT * FROM ['Employee Data$']
Join ['Job Title Table Week 1$'] on ['Job Title Table Week 1$'].[Job ID] = ['Employee Data$'].[Job ID]
ORDER BY Status, [Last Name], [First Name], Salary
join Select [Last Name], SUBSTRING ([Last Name], 1, 1) AS Initial from ['Employee Data$']