This seems to work on a single table query:

CREATE TABLE dbo.InvInstalledFileDetails(

FileDetailsID INT IDENTITY(1,1),

FPath VARCHAR(128),

PrgName VARCHAR(128)

);

GO

INSERT INTO dbo.InvInstalledFileDetails(FPath, PrgName)

VALUES ('c:\Program files\Java\Programs','java.exe'),

('c:\Program files\SQL','sqldb.exe');

GO

SELECT * FROM dbo.InvInstalledFileDetails;

GO

SELECT * FROM dbo.InvInstalledFileDetails fd

WHERE fd.FPath LIKE 'c:\Program files%\Java\%' AND fd.PrgName = 'java.exe';

GO

SELECT * FROM dbo.InvInstalledFileDetails fd

WHERE NOT(fd.FPath LIKE 'c:\Program files%\Java\%' AND fd.PrgName = 'java.exe');

GO

DROP TABLE dbo.InvInstalledFileDetails;

GO