public SelectInterface::join($table, $alias = NULL, $condition = NULL, $arguments = array()) Default Join against another table in the database. This method is a convenience method for innerJoin(). 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 t

public SelectInterface::isPrepared() Indicates if preExecute() has already been called on that object. Return value TRUE is this query has already been prepared, FALSE otherwise. File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 504 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function isPrepared();

public SelectInterface::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 th

public SelectInterface::havingNotExists(SelectInterface $select) Sets a HAVING condition that the specified subquery returns no values. Parameters \Drupal\Core\Database\Query\SelectInterface $select: The subquery that must contain results. Return value $this File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 625 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function havingNotExists(SelectInterfac

public SelectInterface::havingIsNull($field) Sets a condition in the HAVING clause that the specified field be NULL. Parameters $field: The name of the field to check. Return value $this File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 595 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function havingIsNull($field);

public SelectInterface::havingIsNotNull($field) Sets a condition in the HAVING clause that the specified field be NOT NULL. Parameters $field: The name of the field to check. Return value $this File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 605 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function havingIsNotNull($field);

public SelectInterface::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 File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 615 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function havingExists(SelectInterface $select

public &SelectInterface::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. See also \Drupal\Core\Database\Query\ConditionInterface::conditions() File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 556 Class SelectInterface Interface definition for a Select Query object.

public SelectInterface::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:

public SelectInterface::havingCompile(Connection $connection) Compiles the HAVING clause for later retrieval. Parameters $connection: The database connection for which to compile the clause. File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 585 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function havingCompile(Connection $connection);