469,167 Members | 1,277 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Please help with SQL Statement problem

MYSQL Version 4.0.15

Can some anyone tell me what is wrong with the following statement;

select bookings.key1,bookings.surname,bookings.firstname, bookings.bookingseqno,bookings.filetype
from bookings where (bookings.surname='sanderson')
and bookings.bookingseqno IN(select bookingseqno from
bookingcharacteristics where chartype=2 and
(bookingcharacteristics.charvalue = 2))
order by bookings.key1, bookings.bookingseqno

I keep getting a syntax error on this statement, but it works with
MSSQL server.

It is saying I have a syntax error and showing this tidbit in the
error message box; Syntax error near 'select bookingseqno from
bookingcharacteristics where chartype'

Any help would be appreciated.
Jul 19 '05 #1
0 1416

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by J.Bijleveld | last post: by
28 posts views Thread by stu_gots | last post: by
23 posts views Thread by Jason | last post: by
10 posts views Thread by siasookhteh | last post: by
14 posts views Thread by bbawa1 | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.