On Thursday, January 20, 2022, Avi Weinberg <
AviW@gilat.com> wrote:
Hi,
Can I have multiple select statements using one WITH statement?
WITH t AS (
Select A, B from …
)
SELECT A into tableA FROM t where ….;
SELECT B into tableB FROM t where ….;
With q1 as (), q2 as (), q3 as () main_query
David J.