Problem with INNER JOIN

You should use joins that way. You should:

  1. Bake the model table & entity (bin/cake bake model BoutiquesProduits)
  2. Make sure the Produits has a hasMany relationship (see the book)
  3. After the find use innerJoinWith or matching

Matching does select data from the associated table, if you use innerJoin you have to manually select the columns you’re going to use.