Can someone please tell me what is wrong with this statement?
I have upgraded to MySQL 41. and 5.0 and cannot get MySQL to return
the correct results from my database. This same query works correctly
with MS-SQLSERVER.
I have started both 4.1 and 5.0 with the --new function just to be
sure, but I have been told that MySQL does support these statements.
Any help would be greatly appreciated;
select bookings.key1,bookings.surname,bookings.firstname, bookings.bookingseqno,
bookings.filetype from bookings where bookings.bookingseqno in
(select bookingseqno from bookingcharacteristics where
bookingcharacteristics.chartype=1 and
(bookingcharacteristics.charvalue = 2)) and bookings.bookingseqno in
(select bookingseqno from bookingcharacteristics where chartype=2 and
(bookingcharacteristics.charvalue = 3)) order by bookings.key1,
bookings.bookingseqno
It does not return an error, just ALL records, and I know there is
only 1 record that qualifys to be returned.
Are there other switch settings that need to be changed or set in
MySQL?
Thank you much,
Gary Bouchard
ga***@removethis.se.rr.com