Jump to content
We've recently updated our Privacy Statement, available here. ×

HOW TO USE FULL OUTER JOIN IN SPOTFIRE INFORMATION LINK


gurusai sankar

Recommended Posts

HI All,

Please guide me that HOW TO USE FULL OUTER JOIN IN SPOTFIRE INFORMATION LINK because i am unable to see that option (i am only see left, right, inner,freehand). i have to use below query and need to use full outer join. kindly help on this.

SELECT

P1."LINK_PROJ_PROP_ID" AS "LINKPROPID",

P2."PROP_REQ_ID" AS "PROPREQID",

P3."PROPOSAL_ID" as "PROPOSAL_ID",

P1."PROJ_REQ_ID" As "ProjectId",

P1."FORECAST_VALUE_HOURS" AS "DEMANDVALUEHOURS",

P1."FORECAST_VALUE_FTE" AS "DEMANDVALUEFTE",

P1."FORECAST_PERIOD" AS "PROJECTDEMANDPERIOD",

P1."FORECAST_PERIOD_ID" AS "PROJECTFORECAST_PERIOD_ID",

P1."ROLE_NAME" AS "PROJECTROLENAME",

P2."ROLE_NAME" AS "PROPOSALROLENAME",

P2."FORECAST_PERIOD" as "PROPOSALFORECAST_PERIOD",

P2."FORECAST_VALUE_HOURS" AS "PROPOSALFORECASTVALUEHOURS",

P2."FORECAST_VALUE_FTE" AS "PROPOSALFORECASTVALUEFTE",

P2."FORECAST_PERIOD_ID" AS "PROPOSALFORECAST_PERIOD_ID",

nvl(P3."BUSINESS_UNIT",P1."BUSINESS_UNIT") AS "BUSINESSUNIT",

nvl(P3."IT_TOWER",P1."IT_TOWER") AS "ITTOWER"

FROM

"PPM_USR"."PROPOSAL_SP_POSITIONS_V" P2

FULL OUTER JOIN

"PPM_USR"."PPM_PROJECT_SP_V" P1 ON P2."PROP_REQ_ID" = P1."LINK_PROJ_PROP_ID"

and P1."ROLE_NAME" = P2."ROLE_NAME"

and P1."FORECAST_PERIOD_ID" = P2."FORECAST_PERIOD_ID"

full OUTER JOIN

"PPM_USR"."PPM_PROJECT_PROPOSAL_DATA_V" P3 on nvl(P3."PROPOSAL_ID",P1."LINK_PROJ_PROP_ID") =nvl(P2."PROP_REQ_ID",P1."LINK_PROJ_PROP_ID")

Regards,

Guru

Link to comment
Share on other sites

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