27,579
社区成员
发帖
与我相关
我的任务
分享
select deptId from employee where id='00'
“12,33,25”
select * from dept where id in ('12','33','25')
select * from dept where id in (select deptId from employee where id='00')
--如果 dept 表的 id 字段是 int 或 bigint 类型, 可以用下面的
SELECT *
FROM dept AS a
WHERE EXISTS(
SELECT 1
FROM employee AS b
WHERE b.id = '00' AND ','+b.depId+',' LIKE '%,'+ LTRIM(a.id)+',%'
)
SELECT *
FROM dept AS a
WHERE EXISTS(
SELECT 1
FROM employee AS b
WHERE b.id = '00' AND ','+b.depId+',' LIKE '%,'+ a.id+',%'
)
DECLARE @deptid VARCHAR(MAX)
SELECT @deptid = ',' + deptId + ',' FROM employee WHERE id='00'
SELECT * FROM DEPT WHERE CHARINDEX(','+CONVERT(VARCHAR(10),id)+',',@deptid ) > 0