public void VisitJoinTable(LiteJoinTable jtable) { switch (jtable.JoinType) { case JoinTypeEnum.LeftOuterJoin: this.sb.Append(" left outer join "); break; case JoinTypeEnum.RightOuterJoin: this.sb.Append(" right outer join "); break; case JoinTypeEnum.InnerJoin: this.sb.Append(" inner join "); break; default: this.sb.Append(" cross join "); break; } this.sb.Append(" ["); this.sb.Append(jtable.tableName); this.sb.Append("] AS ["); this.sb.Append(jtable.tableAlias); this.sb.Append("] "); if (jtable.filter != null) { this.sb.Append(" ON "); this.VisitFilter(jtable.filter); } }
public void VisitJoinTable(LiteJoinTable jtable) { switch (jtable.JoinType) { case JoinTypeEnum.LeftOuterJoin: this.sb.Append(" LEFT OUTER JOIN "); break; case JoinTypeEnum.RightOuterJoin: this.sb.Append(" RIGHT OUTER JOIN "); break; case JoinTypeEnum.InnerJoin: this.sb.Append(" INNER JOIN "); break; default: this.sb.Append(" CROSS JOIN "); break; } this.sb.Append(" "); this.sb.Append(jtable.tableName); this.sb.Append(" "); this.sb.Append(jtable.tableAlias); this.sb.Append(" "); if (jtable.filter != null) { this.sb.Append(" ON "); this.VisitFilter(jtable.filter); } }