Using PL/SQL in a trigger I construct a data query source like this: x LEFT JOIN y ON x.pidm = y.pidm AND y.aidy = ‘0809’. Then I execute the query in the block with a WHERE on x.pidm. It works fine when there is something in y that fits, but yields nothing at all when there is no y with that pidm, even though there is something in x with that pidm. Forms seems to be treating LEFT JOIN as INNER JOIN, although I know by Message in the trigger code that I have constructed LEFT JOIN.
