title: mysql: CONCAT_WS to select from other table
body: <p>Normally we use concat_ws to join 2 field into 1 string on same table, how do i put a query to select the field value from other table?</p>
  
  <pre><code>GROUP_CONCAT(CONCAT_WS(' - ', item1_from_this_table, item_2_from_other_table) SEPARATOR '\n')
  </code></pre>
  
  <p>is it possible?</p>