sponsored links

Collapse

Announcement

Collapse
No announcement yet.

more that WITH Clause for use in a single SELECT?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CarrieGig
    commented on 's reply
    Thank you! Just what I needed!

  • Scott M
    replied
    Yes, syntax is:

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

    Leave a comment:


  • CarrieGig
    started a topic more that WITH Clause for use in a single SELECT?

    more that WITH Clause for use in a single SELECT?

    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
Working...
X