Hi Will,

The null values will display as <0> when the first table has a zero for a value that has no corresponding value in the second table. So if the first table had a value of 123 and there was no corresponding value in the second table, you would get a result of <123> rather than null.

So if you have null values in the first table, rather than setting it to 0, you should set it to "null". This will return null values rather than <0> in the results.

Please let us know if you have any further questions.

Regards,

Jon