The public members of the TSelectSqlStatement class are listed here.
Field |
Description |
If this sql statement uses set operators to manipulate the result sets of two or more queries, this property stands for the type of set operator. |
Property |
Description |
Joins in from clause. Join is represented by class TLzJoin. Usually, Join count in from is 1. /* ANSI join */ SELECT emp_lname, emp_fname, job_title FROM employee JOIN jobs ON employee.job_id = jobs.job_id; But in the "old" way to do join operations,Theta joins, which use the WHERE clause to establish the filtering criteria, join count is the number of table in from clause. /* Theta join */ SELECT emp_lname, emp_fname, job_title FROM employee, jobs WHERE employee.job_id = jobs. job_id; Join count in this from clause is 2. | |
If this sql statement uses set operators to manipulate the result sets of two or more queries, then LeftStmt is the left side of this select sql. LeftStmt may includes set operators recursively. It's type of TSelectSqlStatement | |
If this sql statement uses set operators to manipulate the result sets of two or more queries, then RightStmt is the right side of this select sql. RightStmt don't includes set operators. It's type of TSelectSqlStatement | |
Value clause of DB2. |
Gudu software http://www.sqlparser.com
|
Send comments about this topic.
|