// generate SQL code for dyadic antijoin operations
DataTableSql DyadicAntijoin(DataTableSql other, DataHeading joinhdg, DataHeading newheading)
{
var sql = _gen.SelectAntijoin(GetFrom(), other.GetFrom(), newheading, joinhdg);
var newtable = CreateFromSql(newheading, sql);
return(newtable);
}
// generate SQL code for dyadic set operations
DataTableSql DyadicSet(DataTableSql other, DataHeading newheading, JoinOps joinop)
{
var sql = _gen.SelectSet(GetFrom(), other.GetFrom(), newheading, joinop);
var newtable = DataTableSql.CreateFromSql(newheading, sql);
return(newtable);
}
// Create new table with previous as a subquery (ran out of slots)
static DataTableSql CreateFromSubquery(DataTableSql table)
{
var newtable = new DataTableSql {
DataType = DataTypeRelation.Get(table.Heading),
SqlSelectText = table._gen.SelectAll(table.GetFrom(), table),
};
return(newtable);
}
