数据库为:sqlservice SQL为:select z0.csid,z0.cs,z1.XX,z2.YYfrom (select csid,cs from V_HR_ORG_TREE_ZUFAwhere org_type='城市公司') z0left join (select csid,cs,RAND()*1000 as XX from V_HR_ORG_TREE_ZUFAwhere org_type='城市公司') z1 on z1.csid=z0.csidleft join (select csid,cs,RAND()*2000 as YY from V_HR_ORG_TREE_ZUFAwhere org_type='城市公司') z2 on z2.csid=z0.csid用的RAND()函数但是为什么随机的数都是一致的......RAND()放到外边还是不行不用子查询结果也是一样的。。。。。。。。。哭了T^T