JoinMeta joinMeta = left.getJoinMeta();
ViewInfo leftView = joinMeta.getPrimaryJoinInfo().getPrimaryTable();
JoinMeta joinMeta2 = right.getJoinMeta();
ViewInfo rightView = joinMeta2.getPrimaryJoinInfo().getPrimaryTable();
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();