SelectTable Class

Represents a table or a subquery in the FROM clause of a SELECT statement.

For a list of all members of this type, see SelectTable members.

Inheritance Hierarchy

System.Object
Devart.Common.SelectStatementNode
Devart.Common.SelectTable

Syntax

[Visual Basic]
Public NotInheritable Class SelectTable 
   Inherits SelectStatementNode

[C#]
public sealed class SelectTable : SelectStatementNode

Example

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

[C#]

OracleSelectStatement statement = new OracleSelectStatement();      
 
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);

[Visual Basic]

Dim statement = New OracleSelectStatement()
 
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)

See Also

Language

SelectTable Class

Inheritance Hierarchy

Syntax

Example

See Also