I have two tables that have 4 columns in common. One of the columns can be blank for some entries. My query will not return these as matches.
Example
Table 1 and Table two have columns that include the following matching information for a given Item
Location
Name
Type
Purpose
For some Items, the Type is (correctly) blank. My query returns the records that match between the tables, except for the Items that have blank Type.
How can I get it to see the blanks as matches? Thanks.
Example
Table 1 and Table two have columns that include the following matching information for a given Item
Location
Name
Type
Purpose
For some Items, the Type is (correctly) blank. My query returns the records that match between the tables, except for the Items that have blank Type.
How can I get it to see the blanks as matches? Thanks.