SelectQuery::leftJoin
public function SelectQuery::leftJoin
public SelectQuery::leftJoin($table, $alias = NULL, $condition = NULL, $arguments = array())
Left Outer Join against another table in the database.
Parameters
$table: The table against which to join.
$alias: The alias for the table. In most cases this should be the first letter of the table, or the first letter of each "word" in the table.
$condition: The condition on which to join this table. If the join requires values, this clause should use a named placeholder and the value or values to insert should be passed in the 4th parameter. For the first table joined on a query, this value is ignored as the first table is taken as the base table. The token %alias can be used in this string to be replaced with the actual alias. This is useful when $alias is modified by the database system, for example, when joining the same table more than once.
$arguments: An array of arguments to replace into the $condition of this join.
Return value
The unique alias that was assigned for this table.
Overrides SelectQueryInterface::leftJoin
File
- includes/database/select.inc, line 1346
Class
- SelectQuery
- Query builder for SELECT statements.
Code
public function leftJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) { return $this->addJoin('LEFT OUTER', $table, $alias, $condition, $arguments); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!select.inc/function/SelectQuery::leftJoin/7.x