http://bakery.cakephp.org/articles/view/quick-tip-doing-ad-hoc-joins-in-model-find
Minimal code for join:
$this->find(
'all',
array (
'joins' => array (
array (
'table' => 'my_table',
'alias' => 'MyTable',
'conditions' => 'MyTable.foreign_key = '.$this-
>alias.'.id'
)
)
)
);
On Nov 19, 2:24 am, kdubya <kenwin...@winanstech.com> wrote:
> On Nov 7, 2:35 pm, Thiago Nuic Vidigal <tvidi...@gmail.com> wrote:
>
> > You can include other tables in the query using the 'joins' option of the
> > Model->find method.
>
> This sound like the solution to a problem I am trying to solve but I
> have looked in the Manual and can find almost nothing about "joins"
> option to "find()'. Can you give an example of a "find()" that uses
> "joins"? I am looking for the specific syntax.
>
> Thank you,
> Ken
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-...@googlegroups.com.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=.
