ok doing my best here to duplicate what you are asking:

CREATE TABLE dbo.vComputer(

Guid VARCHAR(128),

Name VARCHAR(128)

);

GO

INSERT INTO dbo.vcomputer(Guid, name)

VALUES ('333','PC1'),

('222','pc2'),

('111','PC3');

GO;

CREATE TABLE dbo.InvInstalledFileDetails(

FileDetailsID INT IDENTITY(1,1),

_ResourceGuid varchar(128),

FPath VARCHAR(128),

PrgName VARCHAR(128)

);

GO

INSERT INTO dbo.InvInstalledFileDetails(_ResourceGuid, FPath, PrgName)

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

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

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

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

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

GO;