Hey all,
My query has multi-field joins between 2 tables. Is it possible to include Null values on both sides of the joined tables as equal values in one of the joins, so the records relate?
In this case the first join is on actual values (the normal way), but the second could have null on both sides, which I'd want to relate as equal.
Thanks
My query has multi-field joins between 2 tables. Is it possible to include Null values on both sides of the joined tables as equal values in one of the joins, so the records relate?
In this case the first join is on actual values (the normal way), but the second could have null on both sides, which I'd want to relate as equal.
Thanks