i have 2 tables that i am linking on a field that matches with null values on both tables but it either pulls nothing or when i put a right join pulls just one tables data.
i have also confirmed both are pulling from the same data source, so no issues with field properties and confirmed they are null values in each field within both tables.
Is there a trick to this?
Thanks!
i have also confirmed both are pulling from the same data source, so no issues with field properties and confirmed they are null values in each field within both tables.
Is there a trick to this?
Thanks!