SELECT
 t1.filename AS file,
 t2.filename AS parent1,
 t3.filename AS parent2 FROM files AS t1
INNER JOIN
 files AS t2
 ON t2.fileID = t1.parentID
INNER JOIN
 files AS t3
 ON t3.fileID = t2.parentID
WHERE
 a1.fileID = 'the file you are looking for';

CREATE proc GetParent
@Child INT,
@Parent INT output
AS
SELECT @Parent = o_parentno
FROM         phillip
WHERE     o_projectno = @Child
 
CREATE proc GetAllParent
@ChildID INT
AS
	if @ChildID != 0
		BEGIN
			DECLARE @CurrentParent INT
			while @ChildID != 0
				BEGIN
					exec GetParent @ChildID, @Parent = @CurrentParent output
					SELECT @CurrentParent
					SET @ChildID = @CurrentParent
					if @ChildID <= 0 
						break
					ELSE
						continue
				END
		END

GetAllParent 27937