title: I need to compare results from two different tables to get the number of occurrence
body: <p>I have a database with 2 tables:
  Table 1 is Entries (userID, number1, number2, number3, number4, number5, number6)
  Table 2 is Result (number1, number2, number3, number4, number5, number6) </p>
  
  <p>The Entries table stores 6 numbers guessed for each userID and has about 1,200 rows already.
  The Result table stores 6 numbers and has only one row.</p>
  
  <h2>The problem now is:</h2>
  
  <p>I need to generate a report that will
  1. compare the 6 numbers in the Result table against each and every row of the Entries table
  2. count the numbers a user guessed correctly. </p>
  
  <p>For example, 
  if the Results were 1,2,3,4,5,6 and 
  userA guessed 1,3,5,7,9,11, then the correct number of guesses for userA user is 3. 
  If userB guessed 2,8,11,12,13,24, then the correct number of guesses for userB is 1. 
  If userC guesses 23,24,25,26,27,28, then the correct number of guesses for userC is 0.</p>
  
  <p>Therefore my report needs to contain 1,200 rows with 2 columns (userID and Correct_Number_of_Guesses).</p>
  
  <p>What is the best approach towards this problem?</p>