select AreauserCode,RtuName from TB_AreaUser as tau right join TB_MaintenanceInfo inf
on inf.RtuName like tau.AreaUSerName+'%' order by AreauserCode
转载于:https://www.cnblogs.com/kunlunmountain/p/7094103.html
select AreauserCode,RtuName from TB_AreaUser as tau right join TB_MaintenanceInfo inf
on inf.RtuName like tau.AreaUSerName+'%' order by AreauserCode
转载于:https://www.cnblogs.com/kunlunmountain/p/7094103.html