ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

more that WITH Clause for use in a single SELECT?

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

  • 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

  • #2
    Yes, syntax is:

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

    Comment


    • CarrieGig
      CarrieGig commented
      Editing a comment
      Thank you! Just what I needed!
Working...
X