Login Register

db\Query $join

$join public property

How to join with other tables. Each array element represents the specification of one join which has the following structure:

[$joinType, $tableName, $joinCondition]

For example,

[
    ['INNER JOIN', 'user', 'user.id = author_id'],
    ['LEFT JOIN', 'team', 'team.id = team_id'],
]

public array $join = null

Links:

http://www.yiiframework.com/doc-2.0/yii-db-query.html#$join-detail

doc_Yii

2016-10-30 16:58:52

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\Query join() join() public method Appends a JOIN part to the query. The first parameter specifies what type of join it is. public $this join ( $type, $table

sphinx\Query join() join() public method Appends a JOIN part to the query. The first parameter specifies what type of join it is. public $this join ( $type, $table

CI_DB_query_builder::join() join($table, $cond[, $type = ''[, $escape = NULL]]) Parameters: $table (string) – Table name to join $cond (string) – The JOIN ON condition $t

db_query db_query($query, array $args = array(), array $options = array()) Executes an arbitrary query string against the active database. Use this function f

db\Query distinct() distinct() public method Sets the value indicating whether to SELECT DISTINCT or not. public $this distinct ( $value = true )$value boolean Wh