<div>
If you do not have where clause add it:<br />
<br />
Where CustName ='ABC' or CustName Is Null<br />
<br />
BTW, <b>null value</b> is not correct us. We could say either null or null mark.<br />
<br />
This is because null is null because it has no value and it is never going to get one.<br />
<br />
This is not my pinion or interpretation. It comes from a book I am studying now.
</div>


If you do not have where clause add it:

Where CustName ='ABC' or CustName Is Null

BTW, null value is not correct us. We could say either null or null mark.

This is because null is null because it has no value and it is never going to get one.

This is not my pinion or interpretation. It comes from a book I am studying now.

<div>
I want to show ZERO'S where the value is null... for the sum of the values with no corresponding lookup value
</div>


I want to show ZERO'S where the value is null... for the sum of the values with no corresponding lookup value

<div>
HuaMinChen,<br />
<br />
Is this different than my post is some way?<br />
<br />
Mike
</div>


HuaMinChen,

Is this different than my post is some way?

Mike

<div>
<div class="content wysiwyg-content">
How do I show the NULL values and not eliminate them when aggregating.<br />
I'm joining on a lookup table and want to show all the lookup table values even though their are not values associated with that value.<br />
<br />
Any ideas?
</div>
</div>


How do I show the NULL values and not eliminate them when aggregating.
I'm joining on a lookup table and want to show all the lookup table values even though their are not values associated with that value.

Any ideas?

Warning: Null value is eliminated by an aggregate or other SET operation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.