David, Wednesday, April 03, 2002, 3:30:52 PM, you wrote: Dy> I have :
Dy> mysql> select version(); Dy> +-------------------+ Dy> | version() | Dy> +-------------------+ Dy> | 4.0.2-alpha-debug | Dy> +-------------------+ Dy> 1 row in set (0.00 sec) Dy> But an error too : Dy> mysql> delete Dy> -> from Dy> -> externallink as link, Dy> -> topic as topic, Dy> -> topiclink as joiner Dy> -> where Dy> -> link.resid = joiner.resid and Dy> -> topic.catid = joiner.catid and Dy> -> topic.rid like "%Industry%"; Dy> ERROR 1064: You have an error in your SQL syntax near 'as link, Dy> topic as topic, Dy> topiclink as joiner Dy> ? Don't use alias in the DELETE statement. You can also have some problems if you are going to use aliases in WHERE clause, look at: http://www.mysql.com/doc/P/r/Problems_with_alias.html Dy> thanks. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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