title: Combining tables in SQL/QlikView
body: <p>Is it possible to combine 2 tables with a join or similar construct so that all non matching field in one group. Some thing like this:
  All employees with a department name gets their real department and all with no department ends up in group "Other".</p>
  
  <p>Department:
  SectionDesc    ID<br>
  Dep1           500<br>
  Dep2           501  </p>
  
  <p>Employee:
  Name           ID<br>
  Anders         500<br>
  Erik           501<br>
  root           0  </p>
  
  <p>Output:
  Anders   Dep1<br>
  Erik     Dep2<br>
  root     Other  </p>
  
  <p>Best Regards Anders Olme</p>