左表匹配右表最新的一条数据

select d.*,
c.Acc_ConfCategoryID
,c.Acc_ConfTypeID
,c.Acc_ConfSeverityID
,e.Name ConfCategoryName --事故类别
,f.Name ConfTypeName --事故类型
,g.Name ConfSeverityName --严重程度
from ACC_AccidentInfo d left join
(select b.* from (select a.*, row_number() over(partition by a.ACC_AccidentInfoID order by a.CreateTime desc) rw
from ACC_AccidentBulletin a) b where b.rw = 1) c on d.ACC_AccidentInfoID=c.ACC_AccidentInfoID left join
Acc_ConfCategory e on c.Acc_ConfCategoryID=e.ACC_ConfCategoryID left join
Acc_ConfType f on c.Acc_ConfTypeID=f.ACC_ConfTypeID left join
Acc_ConfSeverity g on c.Acc_ConfSeverityID=g.ACC_ConfSeverityID