How to use left join yii2

Question

I have this code in yii 1

$criteria->join = 'left join item_attr_val v ON i.item_id=t.id';
$values = array();
                    foreach ($feature as $key => $value) {
                        if ($value == '1')
                            $values [] = $key;
                    }
$criteria->compare('i.attr_value_id', $values);

how can I use in yii2

Answer 1

You Try this One...

$query = Model::find();
$query->join('LEFT JOIN', 'item_attr_val', "item_id = id");

Answer 2

You can use leftjoin.

e.g

$query = ModelName::find();
$query->leftJoin('item_attr_val', "tableName.item_id = tableName2.id");