PHP NilPortugues\Sql\QueryBuilder\Manipulation Select::joinCondition示例

joinCondition() public method

WHERE constrains used for the ON clause of a (LEFT/RIGHT/INNER/CROSS) JOIN.

public joinCondition ( ) : NilPortugues\Sql\QueryBuilder\Syntax\Where
return	NilPortugues\Sql\QueryBuilder\Syntax\Where

示例#1

文件： JoinQuery.php 项目： masnathan/sql-query-builder

 /**
  * @param Select $select
  * @param string $selfColumn
  * @param string $refColumn
  *
  * @return Select
  */
 public function addJoin(Select $select, $selfColumn, $refColumn)
 {
     $select->isJoin(true);
     $table = $select->getTable()->getName();
     if (!isset($this->joins[$table])) {
         $newColumn = array($selfColumn);
         $select->joinCondition()->equals($refColumn, SyntaxFactory::createColumn($newColumn, $this->select->getTable()));
         $this->joins[$table] = $select;
     }
     return $this->joins[$table];
 }