So I have a project I am working on in Access. I have three tables that I need to grab data from, Bookings, Employees,Customers.
Bookings' records just store information about that booking, the employee that booked it (.BookedBy), and the customer that the booking is for.
I need to write a SQL statement that grabs all bookings "bookedBy" X that have a "DateOfJob" between Y and Z.
This is not working:
WHERE Customers.CustomerID = Bookings.CustomerID
AND Bookings.DateOfJob BETWEEN <Y> AND <Z>
X = the EmployeeID number of the person who booked the Booking
Y = the start date that the booking is between
Z = the end date that the booking is between
I know it involves JOIN. But im not really understand how to JOIN three tables.