Example of CakePHP Join

cake_join.php

<?php

// Join example
$result = $this->Product->find('all', array(
    'fields' => array(
        'Product.name',
        'ProductCategory.name'
    ),
    'joins' => array(
        array(
            'table' => 'categories',
            'alias' => 'ProductCategory',
            'type'  => 'LEFT',
            'conditions' => array(
                'Product.category_id = ProductCategory.id'
            )
        )
    ),
    'conditions' => array(
        'Product.condition' => 'new'
    )
));

?>