You are here: Using General SQL Parser > Select Statement > From clause
ContentsIndexHome
PreviousUpNext
From clause

From clause in select statement was represented by JoinTables which is type of TLzJoinList

For more detailed information about join table in from clause, you can check "how to use join table"

JoinTables represents from clause in a hierarchy structure which includes all information in from clause such as join table, join type and join condition, if you only need to fetch table information in from clause, you can use tables instead which is type of TLzTableList

 

Here are some key properties of TLzTable:

  1. TableName, fetch table name or set table name to new value by using this property.
  2. TablePrefix, fetch table owner or set table owner to new value by using this property.
  3. TableType, is type of TLzTableType,
    • lttAttr, it's a ordinary table, use TableAttr to fetch more information.
    • lttFunc, it's a function derived table, use TableFunc to fetch more information.
    • lttExpr, it's an expression that represents a table, use TableExpr to fetch more information.
    • lttSubquery, it's a subquery table, use Subquery to fetch more information.
4. TableAlias, fetch or set table alias string value. 

5. AliasClause, which is type of TLz_AliasClause, you can get more detailed information about table alias using this property. 

 

You can use FromClauseText to get string representation of all from clause. Set FromClauseText to a new string value will set whole from clause. 

 

You can check following demos shipped together with this component to find out more information about how to work with joins in from clause:

  1. jointabledetail
  2. jointablerelation
  3. joinconverter
4. tablefieldrel

Gudu software http://www.sqlparser.com
Send comments about this topic.