public function SelectQueryExtender::addJoin

cis7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
cle7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
elmsmedia7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
icor7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
meedjum_blog7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
mooc7 select.inc public SelectQueryExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())

Join against another table in the database.

This method does the "hard" work of queuing up a table to be joined against. In some cases, that may include dipping into the Schema API to find the necessary fields on which to join.

Parameters

$type: The type of join. Typically one one of INNER, LEFT OUTER, and RIGHT OUTER.

$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.

$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. If omitted, one will be dynamically generated.

$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::addJoin

File

includes/database/select.inc, line 760

Class

SelectQueryExtender
The base extender class for Select queries.

Code

public function addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array()) {
  return $this->query->addJoin($type, $table, $alias, $condition, $arguments);
}
Error | ELMSLN API

Error

×

Error message

  • Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/elmsln_community/api.elmsln.org/includes/common.inc:2791) in drupal_send_headers() (line 1499 of /var/www/html/elmsln_community/api.elmsln.org/includes/bootstrap.inc).
  • Error: Call to undefined function apc_delete() in DrupalAPCCache->clear() (line 289 of /var/www/html/elmsln_community/api.elmsln.org/sites/all/modules/apc/drupal_apc_cache.inc).
The website encountered an unexpected error. Please try again later.