以jibingName=腹痛 字段为例 我们需要按照 jibingName 和 fenxing_id两个字段来进行排序
--------------------------------------------------------------------------------------------修改前----------------------------------------------------------------------------------------------------
顺序按照分型表的id ,fenxing_id 和jibingName 字段比较乱
sql
select t1.*,t2.name as jibingName
from
dt_bzzz_fenxing as t1
LEFT JOIN
dt_bzzz_jibing
AS t2
ON t1.class_id=t2.class_id AND t1.type=t2.type
ORDER BY t1.id
jibingName 打乱了 截图第一张
截图第二张