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

    Outer Join with Null's in join field

    Bill Markham



      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