public JoinTable(AbsTable t1, JoinType j, AbsTable t2, expr on)
{
this.Tbl1 = t1;
this.tbl2 = t2;
this.join = j;
this.on = on;
}
/// <summary>
/// use it once, if used multiple times, the last one will override
/// </summary>
public SelectStatement from(AbsTable table)
{
this.targetTable = table;
return(this);
}
public JoinTable rightJoin(AbsTable t, expr on)
{
return(new JoinTable(this, JoinType.right, t, on));
}
public JoinTable leftJoin(AbsTable t, expr on)
{
return(new JoinTable(this, JoinType.left, t, on));
}
public JoinTable crossJoin(AbsTable t, expr on)
{
return(new JoinTable(this, JoinType.cross, t, on));
}
public JoinTable outerJoin(AbsTable t, expr on)
{
return(new JoinTable(this, JoinType.full, t, on));
}
public JoinTable innerJoin(AbsTable t, expr on)
{
return(new JoinTable(this, JoinType.inner, t, on));
}
