整合查询具有部分中通字段的两张数据表

二合一：

表1：

表2：

SELECT
    `DEV_ID`,
    `BODYSTATE`,
    `BODYUPDATETIME`,
    NULL AS MANUALALARM
FROM
    hs_15_02.mordo_state_history_location_body
where
    DEV_ID = 433
UNION ALL
SELECT
    `DEV_ID`,
    NULL AS BODYSTATE,
    `BODYUPDATETIME`,
    `MANUALALARM`
FROM
    hs_15_02.mordo_state_history_location_manual
where
    DEV_ID = 433

查询结果：

三合一：

表3

SELECT
    `DEV_ID`,
    `BODYSTATE`,
    NULL AS MANUALALARM,
    NULL AS MOVING,
    `BODYUPDATETIME`,
    NULL AS MOVINGUPDATETIME
FROM
    hs_15_02.mordo_state_history_location_body
where
    DEV_ID = 433
UNION ALL
SELECT
    `DEV_ID`,
    NULL AS BODYSTATE,
    `MANUALALARM`,
    NULL AS MOVING,
    `BODYUPDATETIME`,
    NULL AS MOVINGUPDATETIME
FROM
    hs_15_02.mordo_state_history_location_manual
where
    DEV_ID = 433
UNION ALL
SELECT
    `DEV_ID`,
    NULL AS BODYSTATE,
    NULL AS MANUALALARM,
    `MOVING`,
    NULL AS BODYUPDATETIME,
    `MOVINGUPDATETIME`
FROM
    hs_15_02.mordo_state_history_location_move
where
    DEV_ID = 433

查询结果：