title: SQL join two tables by exact combination in common column
body: <p>I am trying to match two tables that have two columns; one with id number the other with type number. </p>
  
  <p>In the first table id number can have different type numbers for example id 1 can have assigned type 1,2,3,4 in the second table id 1 can have assigned type 1,2,4 ... I would like to join the tables by id only if types are exactly the same ... </p>
  
  <p>Thanks</p>