select a.F_Id,a.FileName,c.Name
from File a
inner join UserFile b on a.F_Id=b.F_Id
inner join User c on b.Id=c.Id

------解决方案--------------------
SQL code

 SELECT A.NAME,B.REMARK,C.FILENAME FROM USER A JOIN USERFILE B ON A.ID=B.ID JOIN
 FILE C ON B.F_ID=C.F_ID
-- 如果还要条件就WHERE一下

------解决方案--------------------
SQL code

select a.F_Id,a.FileName,c.Name
from File a
inner join UserFile b on a.F_Id=b.F_Id
inner join User c on b.Id=c.Id

------解决方案--------------------
select m.* , n.* , t.*
from [user] m, userfile n , file t
where m.id = n.id and n.f_id = t.f_id


------解决方案--------------------
∏F_Id,FileName,Name（USER(USERFILE∞FILE))

------解决方案--------------------
SQL code

∏F_Id,FileName,Name（USER∞(USERFILE∞FILE))