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

create view sys_orgp
as
select  
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,',%'))