Last updated Dec 22nd, 2019 | Page history | Improve this page | Report an issue
Support the team building MODX with a monthly donation.
The budget raised through OpenCollective is transparent, including payouts, and any contributor can apply to be paid for their work on MODX.
$292 per month—let's make that $500!Learn more
Add an INNER JOIN clause to the query.
API Docs: xPDOQuery::innerJoin()
void innerJoin ( $class, [ $alias = ''], [ $conditions = array ()], [ $conjunction = xPDOQuery::SQL_AND], [ $binding = null], [ $condGroup = 0])
Grab only Boxes with an Owner named Mark.
$query = $xpdo->newQuery('Box'); $query->innerJoin('Owner','Owner'); $query->where(array( 'Owner.name' => 'Mark', )); $boxes = $xpdo->getCollection('Box',$query);