Select Data Field using Sub Queries

Example 1:
SELECT     Epf_No,EMP_CALLING_NAME, Proc_Date,DeductAmt
FROM         TempDteSumIncentDeduct
 PS
inner join
(
Select EMP_NUMBER,EMP_CALLING_NAME
from    HS_HR_EMPLOYEE
) PS2
On PS.Epf_No = PS2.EMP_NUMBER

Note:
PS & PS2 is Temp DB


Example 2:
Select *
from
(Select EMP_NUMBER,EMP_CALLING_NAME,Epf_No,Proc_Date,DeductAmt
from    HS_HR_EMPLOYEE
PS
inner join
(
SELECT     Epf_No,Proc_Date,DeductAmt
FROM         TempDteSumIncentDeduct
where    Proc_Date = '07/11/2013'
) PS2
On PS.EMP_NUMBER = PS2.Epf_No
) as w

Note:
PS , PS2,W   is Temp DB