deeejay icon

SQL - WITH Clause (CTE)

deeejay | PRO | 01/09/14 03:41:23 PM UTC | 0 ⭐ | 280 👁️ | Never ⏰ | []
SQL |

160 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
WITH 
a AS (SELECT * FROM some_table),
a1 AS (SELECT * FROM some_table2)
SELECT * FROM ( 
    SELECT * FROM a
    ) b 
JOIN ( 
    SELECT * FROM a1
    ) c 
ON b.id = c.id

Comments