select * from a where ID=你自己的ID union all select * from b union all select * from c
select * from a where (ID=你自己的ID) or (部门id<>(select 部门id from a where id=你自己的ID))
DECLARE @T1 TABLE(ID INT,NAME VARCHAR(10),部门id INT ) insert @T1 SELECT 1,'A1',1 UNION ALL SELECT 2,'A2',1 UNION ALL SELECT 3,'B1',2 UNION ALL SELECT 4,'B2',2 UNION ALL SELECT 5,'C1',3 UNION ALL SELECT 6,'C2',3select * from @T1 where 部门id<>(select 部门id from @T1 where name='A1') or name='A1'ID NAME 部门id ----------- ---------- ----------- 1 A1 1 3 B1 2 4 B2 2 5 C1 3 6 C2 3(5 行受影响)
delete from tb where departmenid not in ('example')
union all
select * from b
union all
select * from c
insert @T1
SELECT 1,'A1',1 UNION ALL
SELECT 2,'A2',1 UNION ALL
SELECT 3,'B1',2 UNION ALL
SELECT 4,'B2',2 UNION ALL
SELECT 5,'C1',3 UNION ALL
SELECT 6,'C2',3select * from @T1
where 部门id<>(select 部门id from @T1 where name='A1') or name='A1'ID NAME 部门id
----------- ---------- -----------
1 A1 1
3 B1 2
4 B2 2
5 C1 3
6 C2 3(5 行受影响)