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);
}
}
