So this will do, but then this only works if the software is running as we're getting the path to the exe from the "processes" table before then using the "file" table to get the version info. I could perhaps go straight to the "file" table but I might be guessing where it is or using lots of IN or OR statements so this is one option.