How do you omit output that has no data in the field in a report?
I'm having trouble finding the correct SQL code for a particular report that's used to list of computers that have any version of Adobe Acrobat installed grouped by versions. Issue is there are duplicate records being outputted causing skewed reporting. I'd like it to omit any data that has blank fields in the columns, DISPLAY_VERSION and MACHINE_NAME_GROUPED or to prevent duplicates from being displayed to begin with. The following is what i've been working off of and would appreciate any suggestions. Thanks!
') AS MACHINE_NAME_GROUPED,
MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID)
MACHINE ON (MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID)
AND (DISPLAY_NAME like 'Adobe Acrobat%')
GROUP BY SOFTWARE.ID
ORDER BY DISPLAY_NAME