如何将一个大查询拆分为多个小查询，并将它们附加为单个查询

我有一个大查询，需要更多的时间来执行。我想将查询拆分为多个小查询，然后执行它们，并将它们作为单个结果追加。

select
  mm.Member_Id,
  (SELECT
     SubCategory_Name
   From member_subcategory
   WHERE mm.Admiral_Type_Id = SubCategory_Id) AS Admiral_Type_Id,
  (SELECT
     SubCategory_Name
   From member_subcategory
   WHERE mm.Royalty_Type_Id = SubCategory_Id) AS Royalty_Type_Id,
  (SELECT
     SubCategory_Name
   From member_subcategory
   WHERE mm.Parent_Type_Id = SubCategory_Id) AS Parent_Type_Id,
  (SELECT
     SubCategory_Name
   From member_subcategory
   WHERE mm.Guest_Type_Id = SubCategory_Id) AS Guest_Type_Id,
  mha.First_Name,
  mha.Middle_Name,
  mha.Last_Name,
  mha.Address,
  mha.City,
  mha.State,
  mha.Zip,
  mwa.First_Name    AS Work_First_Name,
  mwa.Middle_Name   AS Work_Middle_Name,
  mwa.Last_Name     AS Work_Last_Name,
  mwa.City          AS Work_City,
  mwa.State         AS Work_State,
  mwa.Zip           AS Work_Zip,
  mrm.Year          AS Royalty_Year,
  mrm.Title         AS Royalty_Title,
  mrm.First         AS Royalty_First,
  mrm.Maiden        AS Royalty_Maiden,
  (CASE WHEN mha.Preferred=0 THEN 'Work Address' WHEN mha.Preferred=1 THEN 'Home Address' END) AS Preferred,
  (select
     msi.MaidenName  AS Spouse_MaidenName
   FROM member_spouse_info msi
   WHERE msi.Member_Id = mm.Member_Id) as Spouse_MaidenName,
  (select
     msi.Mobile      AS Spouse_Mobile
   FROM member_spouse_info msi
   WHERE msi.Member_Id = mm.Member_Id) as Spouse_Mobile,
  (select
     mai.Fleet_Year  AS Fleet_Year
   FROM member_admiral_info mai
   WHERE mai.Member_Id = mm.Member_Id) as Fleet_Year,
  mmt.Admiral_Title,
  mmt.Spouse_Title,
  mmt.Couple_Title,
  (select
     mdi.Year          AS Duchess_Year
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_Year,
  (select
     mdi.College       AS Duchess_College
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_College,
  (select
     mdi.Major         AS Duchess_Major
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_Major,
  (select
     mdi.Sorority      AS Duchess_Sorority
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_Sorority,
  (select
     mdi.Parent_Name   AS Duchess_Parent_Name
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_Parent_Name,
  (select
     mdi.Escort_Name   AS Duchess_Escort_Name
   FROM member_duchess_info mdi
   WHERE mdi.Member_Id = mm.Member_Id) as Duchess_Escort_Name,
  (select
     dp.Duchess_Note   AS Duchess_Note
   FROM duchess_payment dp
   WHERE dp.Duchess_Id = (select
                mdi.Duchess_Id
              FROM member_duchess_info mdi
              WHERE mdi.Member_Id = mm.Member_Id)) as Duchess_Note,
  (select
     em.Year           AS Escort_Year
   FROM escort_master em
   WHERE em.Member_Id = mm.Member_Id) as Escort_Year,
  (select
     em.Name           AS Escort_Name
   FROM escort_master em
   WHERE em.Member_Id = mm.Member_Id) as Escort_Name,
  (select
     em.Parent_Name    AS Escort_Parent_Name
   FROM escort_master em
   WHERE em.Member_Id = mm.Member_Id) as Escort_Parent_Name,
  (select
     em.Notes          AS Escort_Note
   FROM escort_master em
   WHERE em.Member_Id = mm.Member_Id) as Escort_Note,
  (select
     guest.Guest_Name
   FROM guest
   WHERE guest.Member_Id = mm.Member_Id) as Guest_Name,
  (select
     (CASE WHEN mpm.Status=0 THEN 'Current' WHEN mpm.Status=1 THEN 'Past due' WHEN mpm.Status=2 THEN 'Paid' END) AS Payment_Status
   FROM member_payment_master mpm
   WHERE mpm.Member_Id = mm.Member_Id) AS Payment_Status,
  (select
     mpm.Payment_Date
   FROM member_payment_master mpm
   WHERE mpm.Member_Id = mm.Member_Id) AS Payment_Date,
  (select
     mpm.Payment_Method
   FROM member_payment_master mpm
   WHERE mpm.Member_Id = mm.Member_Id) AS Payment_Method,
  (select
     mpm.Payment_Amount
   FROM member_payment_master mpm
   WHERE mpm.Member_Id = mm.Member_Id) AS Payment_Amount
FROM member_master mm,
  member_home_address mha,
  member_work_address mwa,
  member_mailing_title mmt,
  member_royalty_master mrm
where mha.Member_Id = mm.Member_Id
    AND mwa.Member_Id = mm.Member_Id
    AND mmt.Member_Id = mm.Member_Id
    AND mrm.Member_Id = mm.Member_Id
ORDER BY mm.Member_Id;