22,301
社区成员




SqlServer 一个多表连接的语句,没有使用order by ,在使用group by多个字段后顺序不断发生变化,如下图也
select
distinct a4.ID
from
YieldTransit as a1
inner join QueryZL as a2 on a2.YieldTransit_ID = a1.ID
left join QueryZLStuffUP as a3 on a3.QueryZL_ID = a2.ID
left join TestYieldAppraiseProduct as a4 on a4.ID = a3.TestYieldAppraiseProduct_ID
where
group by
a1.id
,a2.ID,
a4.ID,a3.ID
--,a7.Name
--,a9.TypeName
--,a9.ID