I have the following tables:
did department identifier, so we need something that is in employee.did but non on project.did
and I want to retrieve all of the projects whose duedate is not passed, and that all of its workers belong to a department that is not responsible for the project.
now, I don't know how to check if the ddate is over(ddate is due date, and I don't know if it's passed or not), and how to represent it in a query.
I'll show the query I constructed so far:
SELECT Project.pname from Project FULL OUTER JOIN Employee on Project.did <> Employee.did AND ....
(don't know how to check if ddate is passed) is there a function to show date in SQL to compare (so the difference will be positive) or any trick to work with the given info?