Back to home page

OSCL-LXR

 
 

    


0001 -- Aliased subqueries in FROM clause
0002 SELECT * FROM (SELECT * FROM testData) AS t WHERE key = 1;
0003 
0004 FROM (SELECT * FROM testData WHERE key = 1) AS t SELECT *;
0005 
0006 -- Optional `AS` keyword
0007 SELECT * FROM (SELECT * FROM testData) t WHERE key = 1;
0008 
0009 FROM (SELECT * FROM testData WHERE key = 1) t SELECT *;
0010 
0011 -- Disallow unaliased subqueries in FROM clause
0012 SELECT * FROM (SELECT * FROM testData) WHERE key = 1;
0013 
0014 FROM (SELECT * FROM testData WHERE key = 1) SELECT *;