sql 表字段模糊连接

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