title: finding a value in multi-values column
body: <p>I have 2 tables as following: </p>
  
  <p><img src="https://i.stack.imgur.com/9E0mD.png" alt="Original tables look like this"></p>
  
  <p>Tam trying to get the department name of each employee (DepName column in table Emp table) from Dep table:</p>
  
  <p><img src="https://i.stack.imgur.com/d5n3g.png" alt="To be like"></p>
  
  <p>I have written this query: </p>
  
  <pre><code>update Emp
   set DepName= (
   select DepName
   from Dep
  where array_to_string(EmpID, ',') like EmpID
  );
  </code></pre>
  
  <p>It did not update the table Emp with the requested information, although I haven't got any error. Any help?</p>