Class CJoinQuery

CJoinQuery represents a JOIN SQL statement.

Package: system\db\ar
Copyright: 2008-2013 Yii Software LLC
License: http://www.yiiframework.com/license/
Author: Qiang Xue <qiang.xue@gmail.com>
Since: 1.0
Located at x2engine/framework/db/ar/CActiveFinder.php

Methods summary
`public`	# `__construct( CJoinElement $joinElement, CDbCriteria $criteria = null )` Constructor. Constructor. Parameters `$joinElement` `CJoinElement` $joinElement The root join tree. `$criteria` `CDbCriteria` $criteria the query criteria
`public`	# `join( CJoinElement $element )` Joins with another join element Joins with another join element Parameters `$element` `CJoinElement` $element the element to be joined
`public CDbCommand`	# `createCommand( CDbCommandBuilder $builder )` Creates the SQL statement. Creates the SQL statement. Parameters `$builder` `CDbCommandBuilder` $builder the command builder Returns `CDbCommand` DB command instance representing the SQL statement

Properties summary
`public array`	`$selects`	`array()`	# list of column selections list of column selections
`public boolean`	`$distinct`	`false`	# whether to select distinct result set whether to select distinct result set
`public array`	`$joins`	`array()`	# list of join statement list of join statement
`public array`	`$conditions`	`array()`	# list of WHERE clauses list of WHERE clauses
`public array`	`$orders`	`array()`	# list of ORDER BY clauses list of ORDER BY clauses
`public array`	`$groups`	`array()`	# list of GROUP BY clauses list of GROUP BY clauses
`public array`	`$havings`	`array()`	# list of HAVING clauses list of HAVING clauses
`public integer`	`$limit`	`-1`	# row limit row limit
`public integer`	`$offset`	`-1`	# row offset row offset
`public array`	`$params`	`array()`	# list of query parameters list of query parameters
`public array`	`$elements`	`array()`	# list of join element IDs (id=>true) list of join element IDs (id=>true)