9 Replies Latest reply: Mar 17, 2015 11:50 AM by Bill Markham RSS

    Outer Join with Null's in join field

    Bill Markham

      Hi

       

      I need to Outer Join 2 tables that have a single common field to join on.

       

      Many of the values in this join field are Null, but I wish still wish to join on the Null's.

       

      One thing I thought was replacing the Null's in each table with say the text 'FieldIsNull' and then after the join doing a resident load to set these fields back to Null.

       

      Any suggestions on the best way to do this would be welcome.



      Many Thanks,     Bill