hi dharmendr
I use Sp that you told...
select Download.id 'id',Download.url 'url',Download.DownLoadToken 'DownLoadToken',Temp_Users.pcode 'Pcode'
FROM Download
INNER JOIN Temp_Users ON Temp_Users.Authority = Download.Authority
WHERE Download.Authority = @Authority