>I am using an SQL command (with a left outer join) that bring data from two table together. In some cases, where records are missing, the records are added with NULL values. Set NULL off doesn’t apply in select sql commands (so I think). Is there a way to suppress those nulls? Thank you.

See NVL() function.