Code:CREATE OR REPLACE VIEW QRYMATCHITEMS_VW ( SCALE_ID, ITEM_ID, COMPLETE_DT, LONG_TXT, SCALE_NM, STEM_TXT ) AS SELECT DISTINCT item.SCALE_ID, item.ITEM_ID, item.COMPLETE_DT, long_txt.LONG_TXT, scale.SCALE_NM, long_txt_1.LONG_TXT as stem_txt FROM scale , version_item , long_txt , item , long_txt long_txt_1 , version_stem_txt where version_item.RESP_ITEM_TXT_ID = long_txt.LONG_TXT_ID and version_item.ITEM_ID = item.ITEM_ID and long_txt_1.LONG_TXT_ID = version_stem_txt.STEM_TXT_ID (+) and version_item.QUEST_ID = version_stem_txt.QUEST_ID and scale.SCALE_ID = item.SCALE_ID AND item.COMPLETE_DT > to_date( '1/1/1950' , 'mm/dd/yyyy')
should this statement be interpreted like this
Code:LEFT JOIN (long_txt AS long_txt_1 RIGHT JOIN version_stem_txt ON long_txt_1.LONG_TXT_ID=version_stem_txt.STEM_TXT_ID)Code:long_txt_1.LONG_TXT_ID = version_stem_txt.STEM_TXT_ID (+)




Reply With Quote