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: stackoverflow.com/questions/806650/…

minaz
– minaz

2011-09-20 14:50:16 +00:00
Commented Sep 20, 2011 at 14:50 — minaz
– minaz, Commented Sep 20, 2011 at 14:50
I need to join the same table with different criteria

chchrist
– chchrist

2011-09-20 14:59:13 +00:00
Commented Sep 20, 2011 at 14:59 — chchrist
– chchrist, Commented Sep 20, 2011 at 14:59

Rob Wilkerson · Accepted Answer · 2011-09-20 15:31:25Z

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. :-)

diagonalbatman · Accepted Answer · 2011-09-20 14:43:07Z

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

I've read that but it doesn't help. I need to join the same table multiple times

Hardik Sondagar · Accepted Answer · 2013-02-28 17:47:53Z

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

Collectives™ on Stack Overflow

Convert this SQL to cakephp find()

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related