Now assuming this was a working DB, what would be an SQL query could I use to query the DB to tell me which Driver is free on a specific date. The plan is to inject (with php) into the query the date that is required. The query will then display all the drivers who could possibly be used.
I have tried the following :
FROM (Driver INNER JOIN Job ON Driver.DriverID = Job.DriverID) INNER JOIN NonDriverAvailabilityInstance ON Driver.DriverID = NonDriverAvailabilityInstance.DriverID
WHERE (((Job.Time)<>#5/22/2011#)) OR (((NonDriverAvailabilityInstance.Time)<>#5/22/2011#));
But it doesn't work and is displaying driver 1's name 3 times. Which obviously is a null result.
The background to this question is that the taxi company website to which all the drivers have jobs or instances when there busy. Just need to check the DB to tell me which drivers are free on the specific date injected by the php. Then later will come the functionality of updating the Job table with information as to new Jobs.
This isn't a "homework" assignment. Amazingly its for a real project i'm doing for someone, but being a noob web designer I've never had to use a DB in my coding, so i'm new to it all!