join cakphp code example
Example: join cakphp
'joins' => array(
array(
'table' => Environment::read('table_prefix') . 'image_type_languages',
'alias' => 'language',
'type' => 'INNER',
'conditions'=> array(
'ImageType.id = language.image_type_id',
'language.alias = \'' . $language . '\'',
)
),
),