I have 2 tables . One of employees and other breaks. I want to show all records from the Employees table ( LEFT JOIN) and see if any employee rests next Sunday (if have a record in the other table - breaks
SELECT T1.idEmp , T1.fname , T1.lname , T1.number , T2.idGuard , T2.date FROM tblEmp AS T1 LEFT JOIN tblEmpGuard AS T2 ON T1.idEmp = T2.idEmp WHERE date = @date
this just shows me employees having break next Sunday , but not the others.