MySQL使用UNION进行多表联合查询

现在有3张表：mms_material_order (航材)，mms_duty （例行任务），mms_breakdown_order （故障工单），现在要返回3张表中的id, title（标题）, orderNo（编号）, orderType（工单类型）, expirationTime（逾期时间）, faultSimulatorNumber字段。

注意：mms_duty （例行任务）表中没有字段fault_simulator_number ，而且3张表都没有orderType字段，orderType字段是为了区分3张表

SQL语句如下：

SELECT id, title, orderNo, orderType, expirationTime, faultSimulatorNumber FROM (
    SELECT id, title, order_no as orderNo, '2' AS orderType, expiration_time as expirationTime, fault_simulator_number as faultSimulatorNumber FROM mms_material_order WHERE is_deleted = 0
    UNION ALL
    SELECT id, title, order_no as orderNo, '3' AS orderType, expiration_time as expirationTime, '' as faultSimulatorNumber FROM mms_duty WHERE is_deleted = 0
    UNION ALL
    SELECT id, title, order_no as orderNo,