Posted by David Portas on 03/29/06 13:32

chudson007@hotmail.com wrote:
> TableA.ID and TableB.ID are the respective keys, but the problem is
> that they contain multiple Nulls
>
> Regards,
> Ciarán

If they contain nulls then they aren't keys. Every table should have a
key. Fix the design first.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

--

• Next in forum: Re: Stored procedure with unknown numer of paramters, how?
• Prev in forum: Stored procedure with unknown numer of paramters, how?
• Thread view: Re: Problem with a join due to multiple Nulls

[Reply to this message]