Объединение двух запросов SQL

Приветвую. Необходимо объединить два запроса в один. Таблицы джоинятся по полям lpd.PIn = b.employee_id_pin. Как вывести поля из первой и второй таблиц?

SELECT DISTINCT 
lpd.LocationID
,lpd.BusinessUnitId
,lpd.PIN
,DATEADD(DAY,1,EOMONTH(lpd.TimeLine,-1)) AS 'timeline 1 day of month'
,SUM(IIF(lpd.RegTypeEOM NOT IN ('Non-staff','Contractor (Individual 
 Entrepreneur)','Contractor'),lpd.Headcount,NULL)) AS 'Headcount without contractors'
 FROM vEXAMPLE_PIN_Detailed lpd
 GROUP BY 
 lpd.LocationID
,lpd.BusinessUnitId
,lpd.TimeLine
 
-----------------------------------

SELECT
b.location_id
,b.department_id
,b.employee_id_pin
,DATEADD(DAY,1,EOMONTH(b.timeline,-1)) AS 'timeline 1 day of month'
,COUNT (DISTINCT IIF(b.OfficeSubType='OnSite',b.employee_id_pin,NULL)) AS 'OnSite headcount'
,COUNT (DISTINCT IIF(b.OfficeSubType='None',b.employee_id_pin,NULL)) AS 'OffSite headcount'
,COUNT (DISTINCT IIF(b.OfficeSubType='Other',b.employee_id_pin,
             IIF(b.OfficeSubType='MaternityLeave',b.employee_id_pin,
             IIF(b.OfficeSubType IS NULL,b.employee_id_pin,NULL)))) AS 'Other headcount'
FROM DWH_EXAMPLE_BACKUPS b
WHERE b.ed_structure_version_department=dbo.GetCurrentFinYear()
AND (b.employee_assignment_dates_end>=EOMONTH(b.timeline,0) OR b.employee_assignment_dates_end IS 
NULL)
AND (b.employee_dates_termination<>b.timeline OR b.employee_dates_termination IS NULL)

GROUP BY 
b.location_id
,b.department_id
,b.timeline