Correlated Sub-Queries:First Row/Semi-Join

QUERY:

UPDATE PS_JRNL_LN SET jrnl_line_status = ‘3’

WHERE BUSINESS_UNIT='ABC'

AND PROCESS_INSTANCE=5960

AND EXISTS (

SELECT 'X'

FROM PS_COMBO_SEL_06 A

WHERE A.SETID='ABC'

AND A.COMBINATION='OVERHEAD'

AND A.CHARTFIELD='ACCOUNT'

AND PS_JRNL_LN.ACCOUNT BETWEEN A.RANGE_FROM_06

AND A.RANGE_TO_06)

Estimated Cost: 79

Estimated # of Rows Returned: 1

Previous slide

Next slide

Back to first slide

View graphic version