Emp-Salary Emp-Bonous EID salary EID salary 111 10000 111 5000 222 20000 111 2000 333 40000 222 10000 444 30000 333 8000
if Employee is Getting Bonous then need to Remove that bonous from salary and generate the new salary from Emp-Salary Table.
can anyone help with this with sql query
SELECT s.EID, s.Salary - b.Salary AS AdjustedSalary FROM [Emp-Salary] s JOIN [EMp-Bonous] b ON s.EID = b.EID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)