I have two database tables Employee and salary
Where Employee maintains details about employee And the salary table maintains data about Payroll entry.
Iwant the query for
Select the employees who have not got salary for a particular month
I have already tried this
select employee.empid , salary.empid , employee.name from salary , employee where salary.month='$month' and salary.year='$year' and employee.empid!=salary.empid
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!