Re: CTE in SQL

[Carel <coteijgeler@xxxxxxxxx>]

Why not use UNION iinstead ;stop;


Op 3-6-2021 om 22:21 schreef K Crawford:
> I am teaching myself the CTE of SQL.  Got it working great.  Have one
> question.
> I have one CTE that I want to use for two separate  SQL statements.
> In ACS Run SQL Scripts it would look something like this.
>
> with cte_temp as (
>       select fld01, fld02
>       from table1
>       where fld3 = 'ABCD'
>       )
> select fld01
> from cte_temp
> where fld2 = 'X'
> ;stop;
> select fld01
> from cte_temp
> where fld2 = 'Z'
>
> Can this be done?  I ended up copy the cte_temp to the second SQL.