Jump to content

How to write the where clause for this query?


polubothusatish

Recommended Posts

 

SELECT 

G.DESCRIPTION "Geo Name",

GT.DESCRIPTION "Geo Type",

PA.AMOUNT "Adjustment Amount",

PA.WEIGHT "Adjustment Weight",

PAT.DESCRIPTION "Adjustment Type", 

p.INTERNAL_NAME "Provider Name",

p.IS_ADULT "Adult Flag",

p.CODE "Provider Code"

FROM UNU.PROVIDER_ADJUSTMENTS PA

JOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.KEY

JOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEY

JOIN UNU.GEO G on PA.GEO_KEY=G.KEY

JOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEY

--JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEY

WHERE PA.GEO_KEY='&GEOKEY'

Order by P.INTERNAL_NAME,WEIGH

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...