Outer Join on multple columns with some null values
I am trying to join two tables in the data model based on two columns that are present in both tables, ID_1 and ID_2. In table 1 the column ID_1 has no null values, but can have null values in ID_2 and vice versa for table 2.
A non null set may be present in one table but one is null in the other table (e.g. ID_1 and ID_2 not null for a record in table 2 but ID_2 is null in table 1). If I use regular OUTER JOIN I would get this record as a double up, I don't want that to happen.
Is there a simple way of getting the correct output?