sql 表字段模糊连接

select AreauserCode,RtuName from TB_AreaUser as tau right join TB_MaintenanceInfo inf
on inf.RtuName like tau.AreaUSerName+'%' order by AreauserCode

posted @ 2017-06-29 13:56  zklve2  阅读(966)  评论(0)  编辑  收藏  举报