Cakephp 2.x join

$this->Message->find('all', array(
    'joins' => array(
        array(
            'table' => 'users',
            'alias' => 'UserJoin',
            'type' => 'INNER',
            'conditions' => array(
                'UserJoin.id = Message.from'
            )
        )
    ),
    'conditions' => array(
        'Message.to' => 4
    ),
    'fields' => array('UserJoin.*', 'Message.*'),
    'order' => 'Message.datetime DESC'
));

Source: stackoverflow.com

Similar codes

0 vote162 views1 answer
Laravel how to query belongsTo relationship
PHP
0 vote153 views2 answers
How change default value for enum colun in laravel
PHP Laravel
1 vote120 views2 answers
Get file name from url in php
PHP
1 vote91 views1 answer
Laravel data types
PHP Laravel
0 vote137 views1 answer
Laravel nginx permissions
PHP
0 vote141 views1 answer
AuthController
PHP
0 vote117 views1 answer
Laravel controller middleware example
PHP
7 votes165 views3 answers
Laravel migration seed fresh
PHP Laravel
23 votes121 views2 answers
Serve php file
PHP
0 vote133 views1 answer
Install pusher package in laravel
PHP