Convert this SQL to cakephp find()

Question

How can I write this SQL using cakephp find()

SELECT a.user_id FROM answers a
INNER JOIN answers a1 ON a1.question_id=1 AND a1.answer_value='Pooch'
INNER JOIN answers a2 ON a2.question_id=2 AND a2.answer_value='Peach'
GROUP BY a.user_id

Thanks in advance

try this: http://stackoverflow.com/questions/806650/in-cakephp-how-to-retrieve-joined-result-from-multiple-tables — minaz, Sep 20 '11 at 14:50

score 0 · Answer 1 · answered Feb 28 '13 at 17:47

0

You can use converter by dogmatic69 here : http://cakephptutor.wordpress.com/2013/02/25/convert-sql-query-to-cakefind/

answered Feb 28 '13 at 17:47

Hardik Sondagar

4,347
3
28
48

score 0 · Answer 2 · answered Sep 20 '11 at 14:43

0

There is a good section of the cookbook that shows you how to join tables, that dont automatically happen through your associations (hasOne, hasMany) etc.

http://book.cakephp.org/view/1047/Joining-tables

answered Sep 20 '11 at 14:43

diagonalbatman

17,340
3
31
31

I've read that but it doesn't help. I need to join the same table multiple times – chchrist Sep 20 '11 at 14:46

score 0 · Accepted Answer · answered Sep 20 '11 at 15:31

0

You can use ad hoc joins or set up a self-referential model association. The former may be the easiest option because it's just building the SQL you already know and understand. :-)

answered Sep 20 '11 at 15:31

Rob Wilkerson

40,476
42
137
192

Convert this SQL to cakephp find()

3 Answers3