HOW TO USE FULL OUTER JOIN IN SPOTFIRE INFORMATION LINK

[gurusai sankar]

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

[Vincent Bernstein]

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