Hi,
I need to implement the below JOIN condition in Qlikview.
select
CLS_OUT_RPT_REQUEST_DTL.REQUEST_ID as REQUEST_ID,
CLS_OUT_RPT_REQUEST_DTL.CLS_OUT_RPT_ID as CLS_OUT_RPT_ID,
CLS_OUT_RPT_REQUEST_DTL.PO_NO as PO_NO,
CLS_OUT_RPT_REQUEST_DTL.CK_REQSTN_NO as CK_REQSTN_NO,
CLS_OUT_RPT_REQUEST_DTL.TOTALITY_ID as TOTALITY_ID,
CLS_OUT_RPT_REQUEST_DTL.REQUEST_TIMESTAMP as REQUEST_TIMESTAMP,
CLS_OUT_RPT_REQUEST_DTL.USR_EML_ID as USR_EML_ID,
THRD_PTY.TOTALITY_ID as TOTALITY_ID1,
THRD_PTY.TRANS_CAT_CD as TRANS_CAT_CD,
THRD_PTY.VER_NO as VER_NO,
THRD_PTY.THRD_PTY_LD_DT as THRD_PTY_LD_DT,
THRD_PTY.PO_NO as PO_NO1,
THRD_PTY.PO_VER_ID as PO_VER_ID,
THRD_PTY.CK_REQSTN_NO as CK_REQSTN_NO1,
THRD_PTY.TRANS_TYP_CD as TRANS_TYP_CD,
THRD_PTY.TRANS_SUB_TYP_CD as TRANS_SUB_TYP_CD,
THRD_PTY.THRD_PTY_LD_TYP_ID as THRD_PTY_LD_TYP_ID,
THRD_PTY.DT_PREPD as DT_PREPD,
THRD_PTY.PREPR_FIRST_NM as PREPR_FIRST_NM,
THRD_PTY.PREPR_LAST_NM as PREPR_LAST_NM,
THRD_PTY.ADDR as ADDR,
THRD_PTY.CITY as CITY,
THRD_PTY.STT_PROVN as STT_PROVN,
THRD_PTY.PHN_NO as PHN_NO,
THRD_PTY.THRD_PTY_LD_FL_NM as THRD_PTY_LD_FL_NM,
THRD_PTY.CK_SUM_NO as CK_SUM_NO,
THRD_PTY.CMPND_CD as CMPND_CD,
THRD_PTY.EML as EML,
THRD_PTY.YR_MJRTY_ACT_CMPLTD as YR_MJRTY_ACT_CMPLTD,
THRD_PTY.CALN_MO_YR_DATA_SUBN as CALN_MO_YR_DATA_SUBN,
THRD_PTY.THRPUTC_CD as THRPUTC_CD,
THRD_PTY.PROTCL_NO as PROTCL_NO,
THRD_PTY.FMV_LOW as FMV_LOW,
THRD_PTY.FMV_HGH as FMV_HGH,
THRD_PTY.PGM_NM as PGM_NM,
THRD_PTY.PGM_STRT_DT as PGM_STRT_DT,
THRD_PTY.PGM_END_DT as PGM_END_DT,
THRD_PTY.VENUS_LOC as VENUS_LOC,
THRD_PTY.PGM_STT_PROVN as PGM_STT_PROVN,
THRD_PTY.TOT_RECS_PRCSSD as TOT_RECS_PRCSSD,
THRD_PTY.TOT_RECS_ACPTD as TOT_RECS_ACPTD,
THRD_PTY.TOT_RECS_REJD as TOT_RECS_REJD,
THRD_PTY.ROW_ADD_TMS as ROW_ADD_TMS,
THRD_PTY.ROW_ADD_EML as ROW_ADD_EML,
THRD_PTY.ROW_ADD_WHO as ROW_ADD_WHO,
THRD_PTY.ROW_UPD_TMS as ROW_UPD_TMS,
THRD_PTY.ROW_UPD_EML as ROW_UPD_EML,
THRD_PTY.ROW_UPD_WHO as ROW_UPD_WHO,
THRD_PTY.THRD_PTY_LD_FL_SZ as THRD_PTY_LD_FL_SZ,
THRD_PTY.DOC_SEQ_NO as DOC_SEQ_NO,
THRD_PTY.SUPLR_NO as SUPLR_NO,
THRD_PTY.SUPLR_SUFX_NO as SUPLR_SUFX_NO,
THRD_PTY.TOTL_REC_PRCSSD as TOTL_REC_PRCSSD,
THRD_PTY.TOTL_REC_UPLD as TOTL_REC_UPLD,
THRD_PTY.ERR_FILE_SENT_DT as ERR_FILE_SENT_DT,
THRD_PTY.SENT_TO_EMAIL_ADDR as SENT_TO_EMAIL_ADDR,
THRD_PTY.ERR_REC_CNT as ERR_REC_CNT,
THRD_PTY.ERR_FL_NM as ERR_FL_NM,
THRD_PTY.LOG_FL_NM as LOG_FL_NM,
THRD_PTY.LOG_FL_SZ as LOG_FL_SZ,
THRD_PTY.LOG_FL_UPD_DT as LOG_FL_UPD_DT,
THRD_PTY.ERR_FL_SZ as ERR_FL_SZ,
THRD_PTY.FILE_ID as FILE_ID,
THRD_PTY.ETL_PRCSS_START_DT as ETL_PRCSS_START_DT,
THRD_PTY.ETL_PRCSS_END_DT as ETL_PRCSS_END_DT,
THRD_PTY.ETL_PRCSS_STAT_CD as ETL_PRCSS_STAT_CD,
THRD_PTY.ETL_PRCSS_ERR_CD as ETL_PRCSS_ERR_CD,
THRD_PTY.ATTEST_IND as ATTEST_IND,
THRD_PTY.ETL_PRCSS_IND as ETL_PRCSS_IND,
THRD_PTY.SUPLR_TRACK_IND as SUPLR_TRACK_IND,
THRD_PTY.THRD_PTY_ATTEST_TMS as THRD_PTY_ATTEST_TMS,
THRD_PTY.INT_UPLOAD_IND as INT_UPLOAD_IND,
THRD_PTY.EXT_UPLOAD_IND as EXT_UPLOAD_IND,
THRD_PTY.ATTEST_DATA as ATTEST_DATA,
THRD_PTY.TOT_RECS_DLTD as TOT_RECS_DLTD,
THRD_PTY.THRD_PTY_ATTEST_DATA_TMS as THRD_PTY_ATTEST_DATA_TMS,
THRD_PTY.MULT_MO_DATA_SUBN as MULT_MO_DATA_SUBN,
THRD_PTY.ATTEST_IND_EML as ATTEST_IND_EML,
THRD_PTY.ATTEST_IND_WWID as ATTEST_IND_WWID
from
JJCUS_HCC_Totality..TOT_READ_ONLY.CLS_OUT_RPT_REQUEST_DTL CLS_OUT_RPT_REQUEST_DTL,
JJCUS_HCC_Totality..TOT_READ_ONLY.THRD_PTY THRD_PTY
where
(((CLS_OUT_RPT_REQUEST_DTL.PO_NO = THRD_PTY.PO_NO)
or (CLS_OUT_RPT_REQUEST_DTL.CK_REQSTN_NO = THRD_PTY.CK_REQSTN_NO))
or (CLS_OUT_RPT_REQUEST_DTL.TOTALITY_ID = THRD_PTY.TOTALITY_ID))
