<div>
It's either the join for that table, the parent table(s), or there's no information for that column.<br />
<br />
EG<br />
<br />
A -&gt; &nbsp;B -&gt; C -&gt; D<br />
<br />
If C is null D will always be null.<br />
<br />
You have info in C then check D's join to ensure the join is proper.
</div>


It's either the join for that table, the parent table(s), or there's no information for that column.

EG

A ->  B -> C -> D

If C is null D will always be null.

You have info in C then check D's join to ensure the join is proper.

<div>
Hello,<br />
<br />
Whenever we have joins the column from other table will have values based on joining column,<br />
so it the joining column has matching data then the data which is there in the relevant column would be displayed otherwise NULL will come.
</div>


Hello,

Whenever we have joins the column from other table will have values based on joining column,
so it the joining column has matching data then the data which is there in the relevant column would be displayed otherwise NULL will come.

<div>
This is what I did... I reduced the query to just show the column I wanted and then built upon it until I came across the issue.<br />
<br />
Thank PortletPaul!
</div>


This is what I did... I reduced the query to just show the column I wanted and then built upon it until I came across the issue.

Thank PortletPaul!

<div>
:)<br />
excellent<br />
hope you enjoyed that salami!
</div>


:)
excellent
hope you enjoyed that salami!

<div>
<div class="content wysiwyg-content">
I have a query that shows many fields/columns.<br />
<br />
There are 6 LEFT OUTER JOINS in this query.<br />
<br />
Everything displays and calculates perfect... except for one field. &nbsp;I have one field in one table that just shows NULL.<br />
<br />
It is the only field in that table that I am trying to show.<br />
<br />
What would be preventing the field from displaying?
</div>
</div>


I have a query that shows many fields/columns.

There are 6 LEFT OUTER JOINS in this query.

Everything displays and calculates perfect... except for one field.  I have one field in one table that just shows NULL.

It is the only field in that table that I am trying to show.

What would be preventing the field from displaying?

SQL query showing NULL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.