Search results

I need to create a query which will show what pens on todays date do not have a bookings in them. The two tables i would need to use are: Booking Booking_number (which is the primary key) Pen_number (which is the foreign key) start_date end_date Pen Pen_number (primary key)...

Hey, Well i have to create a query that will enable me to make a report displaying the average length of stay of the dogs i have in my dog kenel database. I know this would need to be done using my booking table which holds all the information on what dogs i have staying and what length of time...