--first query displays details

select emp_code , emp_name,emp_dob, emp_join_dt
from emp_mast;

--second query summation -- i know we can do this using join condition but this is just an example of requirement.

select emp_allw_code,sum(salary) from emp_pay
where emp_code = :emp_code ( from the detail query per page for each employee)