I m trying to use ```WITH cte col1 col2 AS SELECT 1 2 UNION NetSuite Professionals #suiteql

I'm trying to use: ```WITH cte (col1, col2) AS ( ...

Alan Fitch

09/13/2021, 10:52 AM

I'm trying to use:

Copy code

WITH cte (col1, col2) AS
(
  SELECT 1, 2
  UNION ALL
  SELECT 3, 4
)
SELECT col1, col2 FROM cte

but it gives me an error