Hi all,
I have two tables that I am trying to query and get the results of. However, I need to pull all the data from BOTH tables and join the data by ID. Right now I'm able to display only results of one table or the other, but not full outer join. My current query is listed below. So is it possible to use full outer join in xPDO? The docs (
http://rtfm.modx.com/xpdo/2.x/class-reference/xpdoquery) don't mention it.
$ctable = $modx->newQuery('Commission');
$ctable->leftJoin('modUserProfile','Profile',array('Profile.internalKey = Commission.userid'));
$ctable->leftJoin('Venues','Venues',array('Venues.id = Commission.venueid'));//The table VENUES has entries without a commission, so i'm missing some results there.
$table = $modx->getCollection('Commission',$ctable);
Let me know if clarification is needed. Thank you in advance!!
