title: MySQL: Select all records where it matches multiple IDs
body: <p>This is based on a question that was answered <a href="https://stackoverflow.com/questions/21619480/mysql-select-records-where-joined-table-matches-all-values/21619564#21619564">here</a>.</p>
  
  <p>I need to export relational records to a flat CSV file. It displays a list of employees that match two skills. The export needs to have a separate line for each skill. For example:</p>
  
  <pre>
  EMPID  NAME               SKILLNAME  LEVEL
  1      Fred Flintstone    PHP        Basic
  1      Fred Flintstone    JQuery     Advanced
  3      Steve Jobs         PHP        Basic
  3      Steve Jobs         JQuery     Advanced
  </pre>
  
  <p>Here's the tables/records and a modified version of the previous answer: <a href="http://sqlfiddle.com/#!2/35fe1" rel="nofollow noreferrer">SQL Fiddle</a></p>
  
  <p>I have tried a few variations but no luck.</p>
  
  <p>Thanks</p>