Cake php 2.x joins

$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

8 votes295 views5 answers
Time function in php
PHP
48 votes301 views3 answers
Php cli display errors
PHP
0 vote338 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
3 votes315 views3 answers
Logout in laravel 8
PHP
0 vote309 views1 answer
How to get local current time in laravel
PHP
0 vote282 views1 answer
How assign current date to input type date html in php
PHP
3 votes303 views1 answer
Php loop through json
PHP
2 votes381 views1 answer
Get name custom post type wordpress
PHP
56 votes453 views6 answers
Laravel seeder
PHP Laravel
27 votes306 views4 answers
Common array methods php
PHP