Represents a table or a subquery in the FROM clause of a SELECT statement.
This example shows how SelectTables can be used to create a SelectStatement object representing the following query:
SELECT * FROM test.dept tDept, test.emp tEmp
PgSqlSelectStatement statement = new PgSqlSelectStatement();
statement.Columns.Add("*");
// Create SelectTables, specify their schemas, names and aliases.
SelectTable dept = new SelectTable("test", "dept", "tDept");
SelectTable emp = new SelectTable("test", "emp", "tEmp");
statement.Tables.Add(dept);
statement.Tables.Add(emp);
Dim statement = New PgSqlSelectStatement()
statement.Columns.Add("*")
' Create SelectTables, specify their schemas, names and aliases.
Dim dept = New SelectTable("test", "dept", "tDept")
Dim emp = New SelectTable("test", "emp", "tEmp")
statement.Tables.Add(dept)
statement.Tables.Add(emp)