Adding a category to a report even if its null

[lifo]

So I created a custom report with all workstations and servers but I want to add a SQLVersion column but when I do it only displays the results if I have SQL installed. Can I have it display the full results and just leave that column blank if there is no SQL on that asset?

[RCorbeil · Accepted solution]

Use a LEFT JOIN against the software instead of the default INNER JOIN.

W3 Schools links:
INNER JOIN
LEFT JOIN