How to make a join on query with cakephp?

@ryan.murray 

To make a join query in CakePHP, you can use the contain method or the joins method. Here are the steps to achieve this:

1. Using the contain method:

1
2
3
4

$query = $this->ModelName->find()
    ->contain(['RelatedModel']);

$results = $query->all();

In this example, replace ModelName with the name of your model class and RelatedModel with the name of the related model you want to join.

1. Using the joins method:

1
2
3
4
5
6
7
8
9

$query = $this->ModelName->find()
    ->join([
        'table' => 'related_models',
        'alias' => 'RelatedModel',
        'type' => 'INNER',
        'conditions' => 'RelatedModel.id = ModelName.related_model_id'
    ]);

$results = $query->all();

Replace ModelName with the name of your model class, RelatedModel with the name of the related model, and related_model_id with the foreign key column linking the two models.

This method allows you to specify the table, alias, type (e.g. INNER, LEFT, RIGHT), and conditions for the join.

Remember to replace the table and column names with the actual names used in your database schema.