Im trying to create a query that will list all the computers a piece of software is installed on. The systems are in there own table called system and identified by a number called system_id. The software is in the table sys_sw_software and the ID tied to the system_id is called system_id.
I would like to search for the name of a piece of software which is called software_name and then get a list of all the systems that its installed on from system table.
inner join sys_sw_software on sys_sw_software.system_id = system.system_id
where sys_sw_software.timestamp = system.timestamp