Report - Software 'A' version, but only if Software 'B' is installed?
Struggling with a SQL report.
I'm wanting to return the machine ID, and the software 'A' title, but only if software 'B' exists.
This is the SQL query I'm using - but I don't know how to filter to only show if Software B exists.
Select MACHINE.NAME as Computer_Name,SOFTWARE.DISPLAY_NAME as Application_Name,display_version,IP from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%Software Title A%' order by DISPLAY_NAME
Any help greatly appreciated! My SQL-foo is weak.
Please log in to answer
Posted by: flip1001 4 years ago