public Select::innerJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) Inner Join against another table in the database. Parameters $table: The table against which to join. May be a string or another SelectQuery object. If a query object is passed, it will be used as a subselect. Unless the table name starts with the database / schema name and a dot it will be prefixed. $alias: The alias for the table. In most cases this should be the first letter of the table, or the first l

public Select::havingCompile(Connection $connection) Compiles the HAVING clause for later retrieval. Parameters $connection: The database connection for which to compile the clause. Overrides SelectInterface::havingCompile File core/lib/Drupal/Core/Database/Query/Select.php, line 312 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function havingCompile(Connection $connection) { $this->having->compile($connection, $this); }

public Select::havingArguments() Gets a list of all values to insert into the HAVING clause. Return value array An associative array of placeholders and values. Overrides SelectInterface::havingArguments File core/lib/Drupal/Core/Database/Query/Select.php, line 297 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function havingArguments() { return $this->having->arguments(); }

public Select::havingExists(SelectInterface $select) Sets a HAVING condition that the specified subquery returns values. Parameters \Drupal\Core\Database\Query\SelectInterface $select: The subquery that must contain results. Return value $this Overrides SelectInterface::havingExists File core/lib/Drupal/Core/Database/Query/Select.php, line 346 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function havingExists(SelectInterface $sele

public Select::havingCondition($field, $value = NULL, $operator = NULL) Helper function to build most common HAVING conditional clauses. This method can take a variable number of parameters. If called with two parameters, they are taken as $field and $value with $operator having a value of IN if $value is an array and = otherwise. Parameters $field: The name of the field to check. If you would like to add a more complex condition involving operators or functions, use having(). $value: The valu

public &Select::havingConditions() Gets a list of all conditions in the HAVING clause. This method returns by reference. That allows alter hooks to access the data structure directly and manipulate it before it gets compiled. Return value array An array of conditions. Overrides SelectInterface::havingConditions See also \Drupal\Core\Database\Query\ConditionInterface::conditions() File core/lib/Drupal/Core/Database/Query/Select.php, line 290 Class Select Query builder for SELECT state

public Select::hasAllTags() Determines if a given query has all specified tags. Parameters $tags: A variable number of arguments, one for each tag to check. Return value TRUE if this query has been marked with all specified tags, FALSE otherwise. Overrides AlterableInterface::hasAllTags File core/lib/Drupal/Core/Database/Query/Select.php, line 159 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function hasAllTags() { return !(bool

public &Select::getUnion() Returns a reference to the union queries for this query. This include queries for UNION, UNION ALL, and UNION DISTINCT. Because this method returns by reference, alter hooks may edit the tables array directly to make their changes. If just adding union queries, however, the use of the union() method is preferred. Note that this method must be called by reference as well: $fields =& $query->getUnion(); Return value A reference to the union query array stru

public Select::hasTag($tag) Determines if a given query has a given tag. Parameters $tag: The tag to check. Return value TRUE if this query has been marked with this tag, FALSE otherwise. Overrides AlterableInterface::hasTag File core/lib/Drupal/Core/Database/Query/Select.php, line 152 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function hasTag($tag) { return isset($this->alterTags[$tag]); }

public Select::having($snippet, $args = array()) Adds an arbitrary HAVING clause to the query. Parameters $snippet: A portion of a HAVING clause as a prepared statement. It must use named placeholders, not ? placeholders. $args: (optional) An associative array of arguments. Return value $this Overrides SelectInterface::having File core/lib/Drupal/Core/Database/Query/Select.php, line 304 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public