title: Combine two column result into one column mysql
body: <p>I got a quick question that has been bugging me. How can I combine a column in two different table into a single column</p>
  
  <p>Example of table:</p>
  
  <pre><code>Employee 
  emp_no emp_name
       1 frieza
       2 bulma
       3 goku`
  
  gender 
  emp_no emp_gender
       1 unknown
       2 female
       3 male
  </code></pre>
  
  <p>I want to combine column <code>emp_name</code> and <code>emp_gender</code> into one column like this:
  <code>column emp_name_gender:frieze,bulma,goku,unknown,female,male</code></p>
  
  <p>Been trying to format this question so it easy to understand, but it takes my time while im doing my work. so im apologize for this simple format question.</p>