巧用SQL中的 like 进展表与表之间的关联

巧用SQL中的 like 进行表与表之间的关联!

create view sys_orgpasselect  sys_users.v_id AS uid,sys_users.userid AS userid,sys_users.username AS username,sys_users.depids AS userdepids,sys_zbdep002.POSTID AS postid,sys_zbdep002.POSTFUNCTION AS pfunction,sys_zbdep002.POSTNAME AS postname,sys_zbdep002.POSTSTATUS AS poststatus,sys_zbdep002.POSTNUM AS postnum,sys_zbdep001.DEPID AS depid,sys_zbdep001.DEPNAME AS depname,sys_zbdep001.deplevel AS deplevel,getParentName(sys_zbdep002.INDEPID,'2') AS deppath from((sys_users left join sys_zbdep001 on((concat(',',sys_users.depid,',') like concat('%,dep-',sys_zbdep001.DEPID,',%')))) left join sys_zbdep002 on((concat(',',sys_users.postid,',') like concat('%,post-',sys_zbdep002.POSTID,',%'))))

在表sys_users 中的post id 为  post-100,post-101

在表sys_zbdep001 中的 id=100 和 id=101 两行数据

关联时使用的 语句为

(concat(',',sys_users.postid,',') like concat('%,post-',sys_zbdep002.POSTID,',%'))