6.8.2 Scope variable names
The following table lists examples of scope variable names.
|
No. |
SQL example |
Name of scope variable |
|---|---|---|
|
1 |
WITH Q1 AS |
-- |
|
2 |
(SELECT * FROM |
|
|
3 |
T0), |
A.T0 |
|
4 |
Q2 AS |
-- |
|
5 |
(SELECT * FROM |
|
|
6 |
Q1) |
Q1 |
|
7 |
SELECT "T1"."C1","X"."C1","Y"."C1" FROM |
-- |
|
8 |
"T1" |
A.T1 |
|
9 |
,"A"."T1" "X" |
X |
|
10 |
,"A"."T2" "Y" |
Y |
- Legend:
-
--: Not applicable.
A: Schema name
TO, T1, T2: Table identifier
X, Y: Correlation name
C1: Column name
Q1, Q2: Query name