Hi Kathir,
On Mon, Mar 19, 2001 at 05:38:55AM -0000, Rama kathiresan kathiresan wrote:
> This is kathir from Uniware Systems, We are developing project on ASP with Backend
>as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query
>
...
> iam selecting the values from 3 different tables using in and not in operators.
>When iam executing the above query it displaying the error as follows:
>
> [TCX][MyODBC]You have an error in your SQL syntax near 'CRXU9021208'')' at line 1
>
MySQL doesn't support IN and NOT IN. The manual and mailing lists describe
alternatives for many cases, but these are less readable (and maybe slower).
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php