title: Select query, join the collection field with other table number field
body: <p>I have two tables:</p>
  
  <p>TABLE: stores</p>
  
  <pre><code>----------------------------------------------
  store_cd    store_nm    active    material_cat_ids
  ---------------------------------------------
  L           Store(L)    Y         20,5
  B           Store(B)    Y         7
  </code></pre>
  
  <p>And
  Table : Material_category</p>
  
  <pre><code>----------------------------------------------------------
  material_cat_id    name                        active
  ----------------------------------------------------------
  20                 Material Category type A    Y
  5                  Material Category type B    Y
  7                  Material Category type C    Y
  </code></pre>
  
  <p>Now I need join between both tables (<code>stores</code> and <code>material_category</code>). With <code>stores</code> having <code>material_cat_ids</code> as a collection and <code>material_category</code> table having <code>material_cat_id</code> as a number field, I can't us the "in" keyword.</p>
  
  <p>Please suggest the best way to join these tables.</p>