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.