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 vote144 views1 answer
Woocoommerce php is account page
PHP Wordpress
1 vote179 views3 answers
Php +=
PHP
0 vote176 views1 answer
Test if php is installed
PHP
1 vote176 views1 answer
Php artisan storage:link not working
PHP
0 vote222 views1 answer
Delete Query with Where Condition in Codeigniter
PHP CodeIgniter
0 vote300 views1 answer
Laravel eloquent update quantity
PHP Laravel
1 vote207 views2 answers
Laravel collection flatten
PHP
1 vote193 views1 answer
XMLHttpRequest post not working
PHP
0 vote206 views1 answer
Best testing tools for php
PHP
40 votes175 views3 answers
H:i:s explode in php by ":"
PHP