gurusai sankar Posted April 1, 2019 Share Posted April 1, 2019 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 More sharing options...
Vincent Bernstein Posted April 1, 2019 Share Posted April 1, 2019 Stupid question but: you can edit SQL, why don't you just select the right columns, and then edit the SQL query to make it full outer yourself Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now