I'm looking to only see this data:

('111','PC1')

which I'm not getting from the query as it seems like what it is doing is including all results where java is not found so from our data it appears to be returning:

('333','PC1'),

('222','pc2'),

('111','PC3')

because of these entries:

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

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

are you not seeing the same results?