In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowed
Summary:
Hi R&A forum:
In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ?
See Code snippet.
Thank you,
Content (required):
In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ?
See Code snippet.
Thank you,
Version (include the version you are using, if applicable):
23A
Code Snippet (add any code snippets that support your topic, if applicable):
with
Query1 as ( -- <- Put your 1st Query text here
select A,
B
...
),
Query2 as ( -- <- Put your 2nd Query text here
select B,
C
...
)
select Query1.A,
Tagged:
0