my vote is for PaulTEG. We assume this is a relational database? If so, this is relational database 101.
There must be a table in the database that contains employees and their department. So
select info .....
from mytable, other_table
where ...
and other_table.deptno=DepartmentOfInterest...