You are here: Symbol Reference > Classes > Common SQL Statement Classes > TSelectSqlStatement Class > public
ContentsIndexHome
PreviousUpNext
public

The public members of the TSelectSqlStatement class are listed here.

Fields
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. 
Properties
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.