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

5 votes175 views2 answers
Php implode associative array
PHP
2 votes92 views2 answers
Laravel custom paginator links view
PHP Laravel
0 vote157 views1 answer
2 days left format in laravel
PHP Laravel
3 votes264 views2 answers
Index.php in codeigniter
PHP CodeIgniter
6 votes126 views3 answers
Current time in laravel migration
PHP
15 votes134 views6 answers
Remove space from string php
PHP
3 votes146 views2 answers
Laravel eloquent search query 2020
PHP Laravel
1 vote172 views1 answer
StorePublicly laravel with name
PHP Laravel
9 votes145 views2 answers
Make resource in laravel
PHP
3 votes130 views1 answer
Php datetime create
PHP