34,838
社区成员




declare @departna varchar(50) ='部门名称'
select a.id
,c.department_name
,b.user_name
,a.text
from textTable a
inner join userTable b on a.user_id = b.user_id
inner join departmentTable c on b.department_id = c.department_id
where c.department_name = @departna