JoinType joinType = root.getJoinMeta().getJoinType();
if(joinType == JoinType.INNER || joinType == JoinType.LEFT_OUTER) {
//We need to proxy the right results to translate to the same primary key as the
//left results and our And and Or Cursor can then take care of the rest
JoinInfo joinInfo = root.getJoinMeta().getPrimaryJoinInfo();
ViewInfoImpl newView = joinInfo.getPrimaryTable();
DboColumnMeta col = joinInfo.getPrimaryCol();
ScanInfo scanInfo = createScanInfo(newView, col);
//FROM an ORM perspective, we join to smaller tables in general as we don't want to blow out memory so do the
//join first(ie. we process left sides first in and and or cursors)
CursorForJoin temp = new CursorForJoin(newView, leftView, leftResults, joinType);
temp.setColMeta(col);