Xrhrft

    SELECT 

      CGI.SALES_BRAND_BSNSS_ID,

      CGI.SALES_BRAND_CD,

      NVL(MTRX. matrix_score_cd,'RV1') MATRIX_SCORE_CD,

      MDL.CORP_GROUP_ID,

      MDL.MKTBRIDGE_RUN MKTBRIDGE_RUN_CD,

      MDL.MKTBRIDGE_GROW MKTBRIDGE_GROW_CD,

      MDL.MACRO_SEG MACRO_SEG_CD

FROM 



      BIRTAB.CGI_ACTIVE_CUST_SEG_V MDL INNER JOIN



      BIRTAB.SBBID_CGI_HIST_XREF CGI ON



      MDL.CORP_GROUP_ID = CGI.CORP_GROUP_ID LEFT JOIN



      BIRTAB.CUST_SEG_SCORE_MATRIX MTRX ON



-- if below two join conditions matches then it need to go to 3rd join condition else ignore all joins, 



            NVL(trim(MDL.ECHECK_DECILE_CD),'%') = trim(MTRX. ECHECK_DECILE_CD) AND 



            NVL(trim(MDL.MACRO_SEG),'%') = trim(MTRX.MACRO_SEGMENT_CD)  AND 



-- if the above two joins matches and below join doesn't matches then ignore below two joins and get result based on above 2 joins 



            NVL(trim(MDL.MKTBRIDGE_RUN),'%') = trim(MTRX.MKT_BRIDGE_RUN_CD) AND



-- if the above three joins matches and below join doesn't matches then ignore below join and get result based on above 3 joins             



            NVL(trim(MDL.MKTBRIDGE_GROW),'%') = trim(MTRX.MKT_BRIDGE_GROW_CD)

    SELECT 

      CGI.SALES_BRAND_BSNSS_ID,

      CGI.SALES_BRAND_CD,

      NVL(MTRX. matrix_score_cd,'RV1') MATRIX_SCORE_CD,

      MDL.CORP_GROUP_ID,

      MDL.MKTBRIDGE_RUN MKTBRIDGE_RUN_CD,

      MDL.MKTBRIDGE_GROW MKTBRIDGE_GROW_CD,

      MDL.MACRO_SEG MACRO_SEG_CD

FROM 



      BIRTAB.CGI_ACTIVE_CUST_SEG_V MDL INNER JOIN



      BIRTAB.SBBID_CGI_HIST_XREF CGI ON



      MDL.CORP_GROUP_ID = CGI.CORP_GROUP_ID LEFT JOIN



      BIRTAB.CUST_SEG_SCORE_MATRIX MTRX ON



-- if below two join conditions matches then it need to go to 3rd join condition else ignore all joins, 



            NVL(trim(MDL.ECHECK_DECILE_CD),'%') = trim(MTRX. ECHECK_DECILE_CD) AND 



            NVL(trim(MDL.MACRO_SEG),'%') = trim(MTRX.MACRO_SEGMENT_CD)  AND 



-- if the above two joins matches and below join doesn't matches then ignore below two joins and get result based on above 2 joins 



            NVL(trim(MDL.MKTBRIDGE_RUN),'%') = trim(MTRX.MKT_BRIDGE_RUN_CD) AND



-- if the above three joins matches and below join doesn't matches then ignore below join and get result based on above 3 joins             



            NVL(trim(MDL.MKTBRIDGE_GROW),'%') = trim(MTRX.MKT_BRIDGE_GROW_CD)

    SELECT 

      CGI.SALES_BRAND_BSNSS_ID,

      CGI.SALES_BRAND_CD,

      NVL(MTRX. matrix_score_cd,'RV1') MATRIX_SCORE_CD,

      MDL.CORP_GROUP_ID,

      MDL.MKTBRIDGE_RUN MKTBRIDGE_RUN_CD,

      MDL.MKTBRIDGE_GROW MKTBRIDGE_GROW_CD,

      MDL.MACRO_SEG MACRO_SEG_CD

FROM 



      BIRTAB.CGI_ACTIVE_CUST_SEG_V MDL INNER JOIN



      BIRTAB.SBBID_CGI_HIST_XREF CGI ON



      MDL.CORP_GROUP_ID = CGI.CORP_GROUP_ID LEFT JOIN



      BIRTAB.CUST_SEG_SCORE_MATRIX MTRX ON



-- if below two join conditions matches then it need to go to 3rd join condition else ignore all joins, 



            NVL(trim(MDL.ECHECK_DECILE_CD),'%') = trim(MTRX. ECHECK_DECILE_CD) AND 



            NVL(trim(MDL.MACRO_SEG),'%') = trim(MTRX.MACRO_SEGMENT_CD)  AND 



-- if the above two joins matches and below join doesn't matches then ignore below two joins and get result based on above 2 joins 



            NVL(trim(MDL.MKTBRIDGE_RUN),'%') = trim(MTRX.MKT_BRIDGE_RUN_CD) AND



-- if the above three joins matches and below join doesn't matches then ignore below join and get result based on above 3 joins             



            NVL(trim(MDL.MKTBRIDGE_GROW),'%') = trim(MTRX.MKT_BRIDGE_GROW_CD)

    SELECT 

      CGI.SALES_BRAND_BSNSS_ID,

      CGI.SALES_BRAND_CD,

      NVL(MTRX. matrix_score_cd,'RV1') MATRIX_SCORE_CD,

      MDL.CORP_GROUP_ID,

      MDL.MKTBRIDGE_RUN MKTBRIDGE_RUN_CD,

      MDL.MKTBRIDGE_GROW MKTBRIDGE_GROW_CD,

      MDL.MACRO_SEG MACRO_SEG_CD

FROM 



      BIRTAB.CGI_ACTIVE_CUST_SEG_V MDL INNER JOIN



      BIRTAB.SBBID_CGI_HIST_XREF CGI ON



      MDL.CORP_GROUP_ID = CGI.CORP_GROUP_ID LEFT JOIN



      BIRTAB.CUST_SEG_SCORE_MATRIX MTRX ON



-- if below two join conditions matches then it need to go to 3rd join condition else ignore all joins, 



            NVL(trim(MDL.ECHECK_DECILE_CD),'%') = trim(MTRX. ECHECK_DECILE_CD) AND 



            NVL(trim(MDL.MACRO_SEG),'%') = trim(MTRX.MACRO_SEGMENT_CD)  AND 



-- if the above two joins matches and below join doesn't matches then ignore below two joins and get result based on above 2 joins 



            NVL(trim(MDL.MKTBRIDGE_RUN),'%') = trim(MTRX.MKT_BRIDGE_RUN_CD) AND



-- if the above three joins matches and below join doesn't matches then ignore below join and get result based on above 3 joins             



            NVL(trim(MDL.MKTBRIDGE_GROW),'%') = trim(MTRX.MKT_BRIDGE_GROW_CD)

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});