Oracle Server side with joins
Oracle Server side with joins
illectronic
Posts: 20Questions: 0Answers: 0
I am trying to get the server-side to work but my main query consists of 2 left joins. Is there any way to modify the code given in the documentation to facilitate this? My query is something like:
select cc.CONTROL_ID,CS.SHORT_STATUS,cc.OWNER,cc.FILE_NAME,CC.LINE_CNT,CC.BYTE_CNT,CC.CREATE_DT,cc.FILE_CKSUM,ca.file_type as txn,
CC.ORG_FILE_NAME,cc.FILE_DIR,CC.INT_EXT_FLG,cc.PID,cc.PRIORITY,cc.OSTIMESTAMP,cc.FINAL_TBL_NAME,cc.CNSL_FILE_MV_LU_ID,CC.LAST_JOB_NAME,
CA.DELIMITER,CA.NO_TOKENS,CA.MINLENGTH,CA.MAXLENGTH,CA.HEAD_DATA,CA.TAIL_DATA
from CNSL_FILE_CONTROL CC
left join CNSL_FILE_ATTRIBUTE CA on CC.CONTROL_ID = CA.CONTROL_ID
left join CNSL_STATUS_CODES CS
select cc.CONTROL_ID,CS.SHORT_STATUS,cc.OWNER,cc.FILE_NAME,CC.LINE_CNT,CC.BYTE_CNT,CC.CREATE_DT,cc.FILE_CKSUM,ca.file_type as txn,
CC.ORG_FILE_NAME,cc.FILE_DIR,CC.INT_EXT_FLG,cc.PID,cc.PRIORITY,cc.OSTIMESTAMP,cc.FINAL_TBL_NAME,cc.CNSL_FILE_MV_LU_ID,CC.LAST_JOB_NAME,
CA.DELIMITER,CA.NO_TOKENS,CA.MINLENGTH,CA.MAXLENGTH,CA.HEAD_DATA,CA.TAIL_DATA
from CNSL_FILE_CONTROL CC
left join CNSL_FILE_ATTRIBUTE CA on CC.CONTROL_ID = CA.CONTROL_ID
left join CNSL_STATUS_CODES CS
This discussion has been closed.