Dan Claroni
Dan Claroni
Explore posts from servers
CDCloudflare DevelopersDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Dan Claroni on 4/27/2024 in #help
using unions with "with" clause
I am trying to do something like the following, but cant figure out how to do this with drizzle syntax. 
WITH common_subquery AS (
    SELECT user_id, column1, column2
    FROM shared_table
    WHERE condition
)
SELECT user_id, column1, column2
FROM common_subquery
JOIN table1 ...
UNION
SELECT user_id, column1, column2
FROM common_subquery
JOIN table2 ...
WITH common_subquery AS (
    SELECT user_id, column1, column2
    FROM shared_table
    WHERE condition
)
SELECT user_id, column1, column2
FROM common_subquery
JOIN table1 ...
UNION
SELECT user_id, column1, column2
FROM common_subquery
JOIN table2 ...
16 replies