db\Query innerJoin()

innerJoin() public method

Appends an INNER JOIN part to the query.

public $this innerJoin ( $table, $on = '', $params = [] )
$table string|array

The table to be joined.

Use a string to represent the name of the table to be joined. The table name can contain a schema prefix (e.g. 'public.user') and/or table alias (e.g. 'user u'). The method will automatically quote the table name unless it contains some parenthesis (which means the table is given as a sub-query or DB expression).

Use an array to represent joining with a sub-query. The array must contain only one element. The value must be a yii\db\Query object representing the sub-query while the corresponding key represents the alias for the sub-query.

$on string|array

The join condition that should appear in the ON part. Please refer to join() on how to specify this parameter.

$params array

The parameters (name => value) to be bound to the query.

return $this

The query object itself

doc_Yii
2016-10-30 16:59:00
Comments
Leave a Comment

Please login to continue.