SQLSelectUnionTables(SQLSelectTable table1, SQLSelectTable table2, bool unionall = false)
{
Table1 = new SQLJoinTable(table1);
Table2 = new SQLJoinTable(table2);
UnionAll = unionall;
}
public SQLSelectTable(SQLSelectTable table) : this(table.GetMainTable(), table.GetSelectFields(), table.GetWhereFields(), table.GetGroupByFields(), table.GetOrderByFields())
{
IsDistinct = table.GetIsDistinct();
}
public SQLJoinTable(SQLSelectTable table) : base(table)
{
}
public SQLCreateView(SQLSelectTable table, string viewname) : base(table)
{
SetViewName(viewname);
}
public void AddWhereInSelect(SQLSelectTable table)
{
SelectInTable = table;
}
public void SetWhereTable(SQLSelectTable table)
{
WhereTable = new SQLJoinTable(table);
}
public SQLSelectExistsTable(string table, SQLVars selectfields, SQLSelectTable wheretable) : this(table, selectfields, new SQLJoinTable(wheretable))
{
}
public void AddSelectTable(SQLSelectTable table)
{
SelectTable = new SQLJoinTable(table);
}
public SQLInsertIntoSelectTable(string nm, SQLVars fields, SQLSelectTable selectable) : this(nm, fields)
{
SelectTable = new SQLJoinTable(selectable);
}
public SQLSelectIntoTable(SQLSelectTable table, string destinationtable = "", string externaldb = "") : base(table)
{
DestinationTable = destinationtable;
ExternalDB = externaldb;
}