Home I am trying to join two tables I want null values to be equivalent to ALL
 Lets say that I have two tables: table 1 columns: A,B,C table 2 columns: D,E,F JOIN Conditions table1.A = table2.D, table1.B=table2.E, table1.C = table2.F  Any column can have a null value. I want null values to be treated as a match for any value. (i.e if A=D and B=E, but C is null. F has two values for A=D and B=E. Both rows should be included in the resultant table) Table1: Table2: A: B: C: D: E: F: a b c a b c e f e a f o q e b f h i j h i k l m l a m o q o q results(show table 2 values...): D: E: F: a b c e a f e b f o q l a m