would it do the mission?

SQL> SELECT
  2  Emp.*, d.Department,
  3  devices = STUFF(
  4  (SELECT ','+a.manufacture+' '+a.Model
  5  FROM TBL_DEVICES a
  6  WHERE a.id = emp.Device_ID
  7  FOR XML PATH()), 1, 1, )
  8  FROM
  9  TBL_ Employees emp
 10  Join TBL_DEPARTMENTS d on emp.Department_ID = d.id
 11  /
devices = STUFF(
        *
ERROR at line 3:
ORA-00923: FROM keyword not found where expected

...
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
...