title: How to get multi-select in one query result using T-SQL
body: <p>I have two query statements, the results for the two statements appear on two lines.</p>
  
  <p>I want to get all result in only one line.</p>
  
  <p>This is the code:</p>
  
  <p><img src="https://i.stack.imgur.com/bWGfM.png" alt="The Code"></p>
  
  <pre><code>select 
      [dbo].[HrPslEmployee].[EmployeeFirstName],
      [dbo].[HrTaWorkPeriod].[NameAR], 
      [StartTime] as ReqStartTime 
  from 
      [dbo].[HrTaEmployeeWorkPeriod]  
  join 
      [dbo].[HrTaWorkPeriod] on [dbo].[HrTaEmployeeWorkPeriod].[WorkPeriodId] = [dbo].[HrTaWorkPeriod].[HrTaWorkPeriodID] 
  join 
      [dbo].[HrPslEmployee] on [dbo].[HrTaEmployeeWorkPeriod].[HrPslEmployeeID] = [dbo].[HrPslEmployee].[HrPslEmployeeID] 
  where 
      [dbo].[HrPslEmployee].[HrPslEmployeeID] = 13 
      and [dbo].[HrTaEmployeeWorkPeriod].[WorkPeriodId] = 2
  
  select 
      [dbo].[HrTaWorkPeriod].[NameAR], [StartTime] as ReqStartTime
  from 
      [dbo].[HrTaEmployeeWorkPeriod]  
  join 
      [dbo].[HrTaWorkPeriod] on [dbo].[HrTaEmployeeWorkPeriod].[WorkPeriodId] = [dbo].[HrTaWorkPeriod].[HrTaWorkPeriodID]
  join 
      [dbo].[HrPslEmployee] on [dbo].[HrTaEmployeeWorkPeriod].[HrPslEmployeeID] = [dbo].[HrPslEmployee].[HrPslEmployeeID]
  where 
      [dbo].[HrPslEmployee].[HrPslEmployeeID] = 13 
      and [dbo].[HrTaEmployeeWorkPeriod].[WorkPeriodId] = 3
  </code></pre>