Как склеить два SQL запроса

select p.*, pr.NUMBER_IN as NUMBER_IN_PR, c.EXECUTE_BEGIN as EXECUTE_BEGIN_C,
  c.EXECUTE_END as EXECUTE_END_C, c.CLIENT_ID as CLIENT_ID_C,
  c.PDV as PDV_C, c.PDV_WITHOUT as PDV_WITHOUT_C, c.PDV_TOTAL as PDV_TOTAL_C,
  c.FIRST_PART_NUMBER_CONTRACT as FIRST_PART_NUMBER_CONTRACT_C,
  c.CREATE_NUMBER as CREATE_NUMBER_C from PLAN_D p join CONTRACT c on
  p.CONTRACT_ID = c.ID join PROPOSAL pr on pr.ID = c.PROPOSAL_ID
  where c.SEND_STATUS = 1 and p.ARCHIVE = 1 order by p.ID

select distinct(sw.NAME_SORT_WORK) from DEVICES d
  join SORT_WORK sw on d.SORT_WORK_ID = sw.ID where d.PROPOSAL_ID = 1

select proposal_id, list(...)
from ...
 group by proposal_id

select ....
from ( --первый запрос
           select ....
      ) as first
left join ( --второй запрос
              select ...
           ) as second on second.proposal_id =first.proposal_id