>I'm doing a left outer join on two tables. I'd like the NULL's for the unmatched values (for the right-side table) to show up as blank's and 0's rather than NULL's. What's the easiest way? TIA.

You can use old-fachioned UNION way to specify 'default' values for right side.