表一:
表二:
语句:
SELECT
`gid`,
`station_id`,
`zone_id`,
`ecode`,
`user_id`,
`user_name`,
`check_user_id`,
`check_user_name`,
`check_time`,
`sign_date`,
`sign_time`,
`longitude`,
`latitude`,
`check_status`,
`address`,
`record_name`,
NULL AS restApplyTime,
NULL AS restCheckerId,
NULL AS restStartTime,
NULL AS restReason,
NULL AS restCheckComment,
NULL AS restEndTime,
NULL AS restStatus
FROM
duty_sign_record
UNION ALL
SELECT
`gid`,
`station_id`,
`zone_id`,
`ecode`,
`user_id`,
`user_name`,
`checker_id` AS restCheckerId,
`checker_name` AS restCheckerName,
`check_time`,
NULL AS sign_date,
NULL AS sign_time,
NULL AS longitude,
NULL AS latitude,
NULL AS check_status,
NULL AS check_user_id,
NULL AS address,
NULL AS record_name,
`apply_time` AS restApplyTime,
`start_time` AS restStartTime,
`reason` AS restReason,
`check_comment` AS restCheckComment,
`end_time` AS restEndTime,
`status` AS restStatus
FROM
`duty_rest`
ORDER BY
gid ASC;