Query help [message #20156] |
Thu, 02 May 2002 10:34 |
jim
Messages: 74 Registered: July 2000
|
Member |
|
|
What is wrong with this query? I can't get it to run for the life of me.
SELECT HOTEL.HOTELNO, HOTEL.HOTELNAME, HOTEL.CITY, GUEST.LASTNAME, BOOKINGS.ROOMNO, BOOKINGS.DATEFROM, BOOKINGS.DATETO
FROM HOTEL INNER JOIN (GUEST INNER JOIN BOOKINGS ON GUEST.GUESTNO = BOOKINGS.GUESTNO) ON HOTEL.HOTELNO = BOOKING.HOTELNO
WHERE (((HOTEL.HOTELNAME='GROSVENOR') AND ((BOOKINGS.DATEFROM)>=#6/1/2002#) AND ((BOOKINGS.DATETO)<=#6/30/2002#))
ORDER BY HOTEL.HOTELNAME;
|
|
|
Re: Query help [message #20166 is a reply to message #20156] |
Thu, 02 May 2002 20:41 |
Vikas Gupta
Messages: 115 Registered: February 2002
|
Senior Member |
|
|
Dear Jim,
I think you are running an MSACCESS query from
Oracle.
Try this:
SELECT HOTEL.HOTELNO, HOTEL.HOTELNAME, HOTEL.CITY, GUEST.LASTNAME, BOOKINGS.ROOMNO, BOOKINGS.DATEFROM, BOOKINGS.DATETO
FROM HOTEL a, GUEST b, BOOKINGS c where
b.GUESTNO = c.GUESTNO and a.HOTELNO = c.HOTELNO
and a.HOTELNAME='GROSVENOR' AND c.DATEFROM >= '06-jan-2002' and c.DATETO <= '30/jun/2002'
ORDER BY a.HOTELNAME;
Regards,
Vikas.
|
|
|