CTE / WITH + alias
Playground: https://drizzle.run/zb932yr9sv2w1nzn916wzvdt
How can i generate the same SQL code (
left join "bar" as cte1)
without6 Replies
i think you can use table aliases?
for some reason, that link just redirects me to just
https://drizzle.run/ D:
so i can't see the code you wrote
and i've checked out table aliases but as far as i can tell you can't use them for CTEs.
šYou have to enable shared playgrounds
That's why you can't see it
you mean @outranker, right?
Yea