CakePHP查询准备与连接语句和子查询 [英] CakePHP query preparation with join statement and subquery
本文介绍了CakePHP查询准备与连接语句和子查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我'学习CakePHP,但是我有一个很大的问题,操作与更复杂的数据库查询。
所以我想执行那种查询:
I', learning CakePHP, but I have a great problem with operating with more complex database queries. So I would like to execute that kind of query:
SELECT p.name, b.value
FROM books b LEFT JOIN projects p
ON b.project_id=p.id
WHERE b.created=
(SELECT max(b.created) FROM books b WHERE b.user_id=1)
AND b.user_id=1
GROUP BY p.name
任何人都帮助我使用cakePHP机制来编写查询?
Can anybody help me write this using cakePHP mechanism for preparing queries?
推荐答案
你的代码应该是类似的东西, ( Book
belongsTo Project
)
Your code should be something similar to this, assuming Book e Project are in relationship (Book
belongsTo Project
)
$this->Book->find
(
'all',
array
(
'fields' => array('Book.value', 'Project.name'),
'conditions' => array
(
'Book.created IN (SELECT MAX(Book.created) FROM books Book WHERE Book.user_id = 1)',
'Book.user_id' => 1
),
'group' => 'Project.name'
)
);
这篇关于CakePHP查询准备与连接语句和子查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文