关于查询的Cakephp有可能吗？

Question

I have a question about cakephp about there $this->query is it possible to combine three query and make it one,?example like this

$this->Training->query(Select sample.* from sample where sample.name like "me")
$this->Training->query(Select sample2.* from sample2 where sample2.name like "you")
$this->Training->query(Select sample3.* from sample3 where sample3.name like "us")

this is a search function combination,2 selectbox and 1 textbox

Answer 1

Simply use UNION clause,

$this->Training->query(Select sample.* from sample where sample.name like "me"
                 UNION Select sample2.* from sample2 where sample2.name like "you"
                 UNION Select sample3.* from sample3 where sample3.name like "us")