more that WITH Clause for use in a single SELECT?

[CarrieGig]

Thank you! Just what I needed!

[Scott M]

Yes, syntax is:

with temp 1 as (
.......
), 
temp2 as (
.......
)
select x .................  can use temp1 and temp 2 here.

[CarrieGig]

Can you have more than one WITH clause that can be used in the SELECT and JOINs?

I need a WITH TEMP1 as (blah blah) and WITH TEMP2 as (blah blah) SELECT fields from File A join TEMP1 join TEMP2