0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for aircraft pilots, mechanics, and enthusiasts

WITH oregon_cte as (
  SELECT Location
   FROM dbo.Users u
   WHERE (Location like '% OR')
  GROUP BY Location
  )
, oregon_city as (
SELECT REPLACE(Location,', OR','') Location
   FROM oregon_cte
  GROUP BY Location
)
, alloregon as (

  SELECT Location FROM oregon_cte
  UNION
  SELECT Location FROM oregon_city
)

SELECT * FROM alloregon

fork query

edited jan 16 18

created jan 16 18 anonymous