Advertisement
Guest User

Untitled

a guest
Sep 17th, 2019
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. -- THIS WORKS:
  2.  
  3. WITH a AS
  4.      (SELECT 1 AS u, 2 AS v, k AS w),
  5.      b AS
  6.      (SELECT 4 AS x, 5 AS y, 6 AS z)
  7. SELECT u, z
  8. FROM a CROSS JOIN b
  9. ;
  10.  
  11. -- WHY NOT THIS? (I ONLY added one NEW line at the END.)
  12.  
  13. WITH a AS
  14.      (SELECT 1 AS u, 2 AS v, k AS w),
  15.      b AS
  16.      (SELECT 4 AS x, 5 AS y, 6 AS z)
  17. SELECT u, z
  18. FROM a CROSS JOIN b
  19. FROM (SELECT 3 AS k) name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement