SELECT top 1 A.JZZDBH,A.XMBH,B.FKFSBH,C.FKFSJB FROM 表1 A
LEFT JOIN 表2 B
ON A.JZZDBH = B.JZZDBH
LEFT JOIN 表3 C
ON B.FKFSBH = C.FKFSBH
order by cast(B.FKFSBH as int) desc
LEFT JOIN 表2 B
ON A.JZZDBH = B.JZZDBH
LEFT JOIN 表3 C
ON B.FKFSBH = C.FKFSBH
order by cast(B.FKFSBH as int) desc
LEFT JOIN 表2 B
ON A.JZZDBH = B.JZZDBH
LEFT JOIN 表3 C
ON B.FKFSBH = C.FKFSBH
where not exists(select 1 from 表2 where jzzdbh = b.jzzdbh and cast(fkfsbh as int) > b.fkfsbh)