mysql 多张连联查拥有同一张主表该如何写

Question

msysql 联查 组合查询组合查询联查mysqlunion all

Answer 1

SELECT * FROM
(
SELECT '跳转' AS doaction,'印章归还' AS `money`,'' AS `settingid`,
                                            msgid,msgcomment,paynotify.billno,
                                            paynotify.`payenddate` AS `paytime`,
                                            paynotify.`paybegindate`,
                                            seal.docname,
                                            (SELECT elyname FROM employee WHERE employee.`ElyId` = paynotify.`createelyid`) AS createelyname,
                                            sysfunction.*
                                            FROM paynotify 
                                            INNER JOIN sealmovebill seal ON seal.`billno` = paynotify.`billno`
                                            INNER JOIN wftype ON seal.`wftypeid` = wftype.`wftypeid`
                                            INNER JOIN sysfunction ON wftype.`funcid` = sysfunction.`FuncId`                                         
 ) A
UNION ALL
 SELECT * FROM
 (                                          
 SELECT '跳转' AS doaction,paysetting.`paymoney` AS money,paysetting.`settingid`,
                            msgid,msgcomment,paynotify.billno,                           
                            paysetting.`paytime`,
                            paynotify.`paybegindate`,
                            days.docname,
                            (SELECT elyname FROM employee WHERE employee.`ElyId` = paynotify.`createelyid`) AS createelyname,
                            sysfunction.*
                            FROM paynotify 
                            INNER JOIN paysetting ON paysetting.`settingid` = paynotify.`settingid`
                            INNER JOIN dayagreementexecbill days ON days.`billno` = paynotify.`billno`
                            INNER JOIN wftype ON days.`wftypeid` = wftype.`wftypeid`
                            INNER JOIN sysfunction ON wftype.`funcid` = sysfunction.`FuncId`                            
  )B
类似这种可能后面还有其他子表。这个sql语句怎么优化？