public expr notIN(AbsSelect select)
{
return(new InExpression(this, false, select)
{
fieldType = dbType.Bool
});
}
public CompoundSelect intersect(AbsSelect select)
{
return(new CompoundSelect(select_comp_op.intersect, this, select));
}
public CompoundSelect except(AbsSelect select)
{
return(new CompoundSelect(select_comp_op.except, this, select));
}
public CompoundSelect unionAll(AbsSelect select)
{
return(new CompoundSelect(select_comp_op.unionAll, this, select));
}
public View(Database db, string name, AbsSelect select)
{
this.db = db;
this.Name = name;
this.select = select;
}
public InExpression(expr exp, bool InOrNotIn, AbsSelect select)
{
this.exp = exp;
this.inOrNotIn = InOrNotIn;
this.select = select;
}
public ExistsExpression(AbsSelect select)
{
this.select = select;
}
public static expr exists(AbsSelect select)
{
return(new ExistsExpression(select));
}
public virtual View newView(string name, AbsSelect select)
{
return new View(this, name, select);
}
public CompoundSelect(select_comp_op op, AbsSelect select1, AbsSelect select2)
{
this.select1 = select1;
this.select2 = select2;
this.op = op;
}
