troubleshooting Question

Code Help

Avatar of j2911
j2911 asked on
Oracle DatabaseSQL
7 Comments1 Solution420 ViewsLast Modified:
First Part of my issue:

I have written the following code to view the results seen in the attached report called:  .xls.  What I am having a problem with is I cannot include the records for   “RightScenarioMissing” found in the field STAT_CD seen in the attached  First_Run_ReportTEST_ELEMENT_COMPARE_RESULT table.  
Here’s the code I'm talking about:

SELECT
  TECR.COMPR_RUN_ID as COMPR_RUN_ID,
  left.TRAN_ID as LTRAN_ID,
  right.TRAN_ID as RTRAN_ID,
  left.INTFC_NM as INTFC_NM,
  tecr.COMPR_RSULT_STAT_CD as STAT_CD,
  left.TEST_SCNRO_ID as TEST_SCNRO_ID,
  left.EXPTD_UNIQ_DESCR_VALUE_DESC as TRACKING_NR_LEFT,
  right.EXPTD_UNIQ_DESCR_VALUE_DESC as TRACKING_NR_RIGHT
 
FROM
  TEST_ELEMENT_COMPARE_RESULT tecr, TEST_SET_ELEMENT LEFT, TEST_SET_ELEMENT RIGHT
   
WHERE
  LEFT.TEST_SET_ELEM_ID=TECR.TEST_ELEM_COMPR_LEFT_SIDE_ID
  AND RIGHT.TEST_SET_ELEM_ID=TECR.TEST_ELEM_COMPR_RIGHT_SIDE_ID
  AND TECR.COMPR_RUN_ID = 1120

 
How can I include those records and the records I already have in my First_Run_Report?
first-run-report.zip
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros