outer join in stored procedure

[kmesser]

How about:

. . . where . . .

AND rownum = 1;