I have 2 tables: tasks and tasksAssigned. Both are related by the IDTask. I need to see which ones were not assigned on a specific date. I was thinking to check the IDTask assigned on a specific date and compare with the Tasks (which are not going to change as it is the main table); however, everytime I tried to do so the results are empty
SELECT Dailytask.TaskName, T_Desc2.WorkingDate,
FROM Dailytask LEFT JOIN T_Desc2 ON Dailytask.[ID] = T_Desc2.[IDTaskName]
WHERE (((T_Desc2.WorkingDate)=#1/1/2019#) AND ((Dailytask.TaskName) Is Null));
Any thoughts?