Hi there, I am having difficulty doing a few queries in SQL. The first one being:
1. List the details for all visits associated with Ms Anne Logan.
I have built this, but its not working :(
SELECT Guest.FirstName, Guest.Surname, BookingDetails.HotelName, BookingDetails.dateofarrival, BookingDetails.dateofdeparture
FROM employee, BookingDetails
WHERE surname='Logan' AND firstname='Anne'
AND Guest.GuestID = BookingDetails.GuestID
Please help :( Sooo frustrating!