joinType = JoinType.LEFT;
break;
default:
throw new UnsupportedSQLException("Unsupported join type", joinNode);
}
JoinNode join = joinNodes(toJoinNode((FromTable)joinNode.getLeftResultSet(),
required && (joinType != JoinType.RIGHT)),
toJoinNode((FromTable)joinNode.getRightResultSet(),
required && (joinType != JoinType.LEFT)),
joinType);
join.setJoinConditions(toConditions(joinNode.getJoinClause()));
result = join;
}
else if (fromTable instanceof FromSubquery) {
FromSubquery fromSubquery = (FromSubquery)fromTable;
PlanNode subquery = toQueryForSelect(fromSubquery.getSubquery(),