Hi, i have the following tables... Employee, manager, dept & payscale.
I need to find the ratio of manager and employees salary. I found out managers' and employees' salary individually.....
Select sum(p.basicsal) manager_sal from employee e, manager m, payscale p where e.empid = m.empid and p.empid = e.empid;
select sum(p.basicsal) employee_sal from employee e, manager m, payscale p where e.empid != m.empid and p.empid = e.empid;
i need to join above two queries and have to find out the ratio... Can any one help me out....?