Hi all,
I ran this query and have error message:SQL Error: ORA-01799: a column may not be outer-joined to a subquery
01799. 00000 - "a column may not be outer-joined to a subquery"
*Cause: <expression>(+) <relop> (<subquery>) is not allowed.
*Action: Either remove the (+) or make a view out of the subquery.
In V6 and before, the (+) was just ignored in this case.

Here is my query:

select d.description, count(*) as frequency
,to_char(RATIO_TO_REPORT(count(*)) OVER (),'9.999')*100 as PERCENT
from dpv_status_codes d FULL OUTER JOIN name_address_stage n ON
n.partition_id = (select partition_id from dw_prod.partition_map
where file_id =(select file_id from member_files where member_file_group_id =(276398) and last_modified_by =('CleanAddress')))
and d.status_cd = n.dpv_status_cd
group by d.description