You are here

Home » API reference » Drupal 8 » Select.php » Select

protected property Select::$tables in Drupal 8

Same name and namespace in other branches
  1. 9 core/lib/Drupal/Core/Database/Query/Select.php \Drupal\Core\Database\Query\Select::tables

The tables against which to JOIN.

This property is a nested array. Each entry is an array representing a single table against which to join. The structure of each entry is:

array( 'type' => $join_type (one of INNER, LEFT OUTER, RIGHT OUTER), 'table' => $table, 'alias' => $alias_of_the_table, 'condition' => $join_condition (string or Condition object), 'arguments' => $array_of_arguments_for_placeholders_in_the condition. 'all_fields' => TRUE to SELECT $alias.*, FALSE or NULL otherwise. )

If $table is a string, it is taken as the name of a table. If it is a Select query object, it is taken as a subquery.

If $join_condition is a Condition object, any arguments should be incorporated into the object; a separate array of arguments does not need to be provided.

Type: array

File

core/lib/Drupal/Core/Database/Query/Select.php, line 55

Class

Select
Query builder for SELECT statements.

Namespace

Drupal\Core\Database\Query

Code

protected $tables = [];