public static Iexpressionlistitem where_fld_not_in(string tablealias, string fieldname, subquery in_subquery)
{
return(new expression(new operand(new selectfield(tablealias, fieldname)), comparisonoperator.coNotIn, new operand(new selectfield(in_subquery, null))));
}
public static Iexpressionlistitem where_i_eq_subquery(int literalvalue, subquery in_subquery)
{
return(new expression(new literal(literalvalue), comparisonoperator.coEqual, new operand(new selectfield(in_subquery, null))));
}
public static Iexpressionlistitem where_fld_op_subquery(string fieldname, comparisonoperator op, subquery in_subquery)
{
return(new expression(new operand(new selectfield(fieldname)), op, new operand(new selectfield(in_subquery, null))));
}
public static Iexpressionlistitem where_notexists(subquery notexists_subquery)
{
return(new expression(null as Ioperand, comparisonoperator.coNotExists, new operand(new selectfield(notexists_subquery, null))));
}