Joins with nulls
From: Juan Pardillos <sicotom_at_eresmas.com>
Date: 14 Nov 2002 13:37:46 -0800
Message-ID: <6278687.0211141337.3ac55b35_at_posting.google.com>
Hi,
Date: 14 Nov 2002 13:37:46 -0800
Message-ID: <6278687.0211141337.3ac55b35_at_posting.google.com>
Hi,
I've read that performing joins with tables that have null values in some attributes is a dangerous operation, but no example was given. I think that this only can happen if you try to join based on the attributes that can have two null values, due to the problem of how to interpret null values (are two null values equal?). Can this also happen in other circumstances?.
Thanks in advance
P.S. Sorry for so many messages, but I've been studying the normalization theory deeply and some doubts have arised. Received on Thu Nov 14 2002 - 22:37:46 CET