Thanks for your reply, and I think user temp table is the best case.

Sample:

DECLARE @TmpIDAttachment TABLE(

IDActionPerformedAttachment INT,

IDAttachment INT)

INSERT INTO @TmpIDAttachment( IDActionPerformedAttachment ,IDAttachment)

SELECT ActionPerformedAttachment.IDActionPerformedAttachment, dbo.ActionPerformedAttachment.IDAttachment

FROM dbo.ActionPerformed

INNER JOIN dbo.ActionPerformedAttachment ON dbo.ActionPerformed.IDActionPerformed = dbo.ActionPerformedAttachment.IDActionPerformed

WHERE dbo.ActionPerformed.IDProject = P1