Hello, I have a query where I full-outer-join 2 tables, and all the columns other than the join column are numerical columns. For my further calculations i need to pad the unmatched tuples with 0 (zero) instead of NULL so that I can perform meaningful mathematical calculations on them. Is this currently possible?
Thanks a ton! Shruthi