deeejay

SQL - WITH Clause (CTE)

Jan 9th, 2014
326
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. WITH
  2. a AS (SELECT * FROM some_table),
  3. a1 AS (SELECT * FROM some_table2)
  4. SELECT * FROM (
  5.     SELECT * FROM a
  6.     ) b
  7. JOIN (
  8.     SELECT * FROM a1
  9.     ) c
  10. ON b.id = c.id
Advertisement
Add Comment
Please, Sign In to add comment