Quote
... and ((Software.`Name` = 'Malwarebytes Anti-Malware version 1.80.0.1010') AND (Software.`Name` = 'Livedrive'))
Look at that where clause again:
. . .
and Software.Name = 'Malwarebytes Anti-Malware version 1.80.0.10'
and Software.Name = 'Livedrive'
The Name field on any one record cannot hold two values at the same time, so the above will never find any results.
You need to check for one value
or the other, but remember that 'and's and 'or's have different
precedences (order of execution) so you need brackets to make the or operation more "important".
. . .
and
( Software.`Name` = 'Malwarebytes Anti-Malware version 1.80.0.1010')
OR Software.`Name` = 'Livedrive'
)
Also, as Peter says, get into the habit of building your joins explicitly.
Regards, Phill W.