SQLSelectUnionTables(SQLJoinTable table1, SQLJoinTable table2, bool unionall = false)
{
Table1 = table1;
Table2 = table2;
UnionAll = unionall;
}
SQLSelectUnionTables(SQLSelectTable table1, SQLSelectTable table2, bool unionall = false)
{
Table1 = new SQLJoinTable(table1);
Table2 = new SQLJoinTable(table2);
UnionAll = unionall;
}
public SQLCreateView(SQLJoinTable table, string viewname) : base(table)
{
SetViewName(viewname);
}
public SQLJoinTable(SQLJoinTable table) : this(table.GetMainTable(), table.GetJoinTables(), table.GetJoinFields(), table.GetSelectFields(), table.GetWhereFields())
{
}
public void SetWhereTable(string table, SQLVars selectfields)
{
WhereTable = new SQLJoinTable(table, selectfields);
}
public void SetWhereTable(SQLSelectTable table)
{
WhereTable = new SQLJoinTable(table);
}
public SQLSelectExistsTable(string table, SQLVars selectfields, SQLJoinTable wheretable) : this(table, selectfields)
{
WhereTable = wheretable;
}
public void AddSelectTable(SQLJoinTable table)
{
SelectTable = new SQLJoinTable(table);
}
public SQLInsertIntoSelectTable(string nm, SQLVars fields, SQLSelectTable selectable) : this(nm, fields)
{
SelectTable = new SQLJoinTable(selectable);
}
public void AddSelectTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, jointables, joinfields, selectfields, wherefields);
}
public void AddSelectTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, selectfields, wherefields);
}
