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; }