Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Msg 681, Level 16, State 3, Line 1 Attempting to set a non-NULL-able column's value to NULL.

I have the following Query

SELECT P.Id,
P.ProductCode,
P.Name,
P.Family
FROM SALESFORCE...Product2 AS P LEFT OUTER JOIN
SALESFORCE...Apttus_Config2__ProductClassification__c AS PC ON P.Id = PC.Apttus_Config2__ProductId__c
WHERE (P.IsActive = 'True') AND
(P.Family <> 'Synergis Software')

When the query is run, I get the following results.

Msg 681, Level 16, State 3, Line 1
Attempting to set a non-NULL-able column's value to NULL.

Is there something wrong with my query. I am Running SQL Server 2008 R2 (SP1)

Thanks
1 person has
this problem
+1
Reply