Re: Outter join, with conditions on target help

You need to provide for the possibility of a null dttm_stamp. Try this:

select a.asset_id, b.comments, b.dttm_stamp from ps_pi_results a,

     ps_asset_comments b
where a.asset_id = b.asset_id (+)

      and
      nvl(b.dttm_stamp,sysdate) = (SELECT NVL(MAX(C.DTTM_STAMP),SYSDATE)
                        FROM PS_ASSET_COMMENTS C
                        WHERE A.ASSET_ID = C.ASSET_ID)