Re: Multiple SELECT statements Using One WITH statement

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, January 20, 2022, Avi Weinberg <AviW@xxxxxxxxx> 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.