Hi all,
I am having serious problems creating my queries. I keep getting the "Data type mismatch in expression" error whenever I try to add a new query.
I have 5 tables...
Booking - bookingcode, delegatecode, eventcode, bookingfee, bedandbreakfast, bedandbreakfastfee, presenting?
Delegate - delegatecode, delegatename, delegateaddress, delegatephone
Course - coursecode, coursedate, coursetitle, coursefee, courseduration
Venue - venuecode, venueaddress, venuename, venuecost, venuephone
Event - eventcode, venuecode, coursecode, eventname, eventdate, presenter
My queries in SQL statements are as follows...
Code:
select coursetitle, eventdate, venuename
from course, event, venue
where course.coursecode = event.coursecode
and venue.venuecode = event.venuecode;
select venuename, count(bedandbreakfast) as totalbb
from venue, booking, event
where booking.eventcode = event.eventcode
and event.venuecode = venue.venuecode
and bedandbreakfast='Yes' group by venuename;
select delegatename, presenting, bookingfee
from booking, delegate
where presenting = "No"
and booking.delegatecode = delegate.delegatecode;
select delegatename, bedandbreakfast, bedandbreakfastfee from booking, delegate
where booking.delegatecode = delegate.delegatecode;
select delegatename, bookingfee, presenting from delegate, booking
where booking.delegatecode = delegate.delegatecode;
Thanks in advance for any help.