MySQL如何将三个的不同字段一起按时间排序查询数据？

Question

我有三张表
bulldozer_info 进厂表

这表有字段id, license_number、begin_time, type

refuse_treatment_plant 出厂表
这表有字段id, license_number、leave_time, type

input_output_status 驶入驶出状态表
这表有字段id, type, explanation

现在我想将这三个一起查询，变成一个记录表

id, license_number、entry_time, begin_time, type, explanation

然后按照entry_time, leave_time进行排序

查询结果V1

select 
    b.id,r.id AS entryID,  b.license_number, begin_time, entry_time AS entryTime, b.driving_status as leaveStatus,  r.driving_status as entryStatus
from
    bulldozer_info b
  JOIN  refuse_treatment_plant r on b.id=r.id
order by 
    entry_time, begin_time
    limit 0, 200;

Answer 1

select 
    id, license_number、entry_time, leave_time, type, explanation
from
    bulldozer_info  b 
        join refuse_treatment_plant  r on b.id=r.id
        join input_output_status i on i.id=r.id
order by 
    entry_time, leave_time