Please help!! Sub Select Problem with MySQL 4.1

[Gary Bouchard]

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