title: SQL how to search a many to many relationship
body: <p>I have a database with two main tables <code>notes</code> and <code>labels</code>.  They have a many-to-many relationship (similar to how stackoverflow.com has questions with labels).  What I am wondering is how can I search for a note using multiple labels using SQL?  </p>
  
  <p>For example if I have a note "test" with three labels "one", "two", and "three" and I have a second note "test2" with labels "one" and "two" what is the SQL query that will find all the notes that are associated with labels "one" and "two"?</p>