How to get data from two tables in sql

select * from [user] u inner join
(
select userid,filename,publihsedby, date,row_number()over (partition by userid order by convert(varchar(50),cast(date as datetime),102) desc) as rno
from userfiles) f
on u.userid=f.userid where f.rno=1