LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Join matches on null values

    Employee
    Posted 08-15-2013 03:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: UisceBeatha

    Hi,

    I've noticed that when there are null values in the columns of data being joined, the null values match each other. Is this by design as I think I remember this doesn't happen in SQL.

    Thanks

    Barry


  • 2.  RE: Join matches on null values

    Employee
    Posted 08-16-2013 07:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Yes, this is working as designed.

    Cheers
    Rich