You can achieve a similar thing with the WHERE column IN (SELECT column FROM table WHERE ..) subselect. In the current version of MySQL, this is not yet supported, but I've heard fearies tell that it will be in version 4.1, or else some other version to be released in the somewhere near future.
---------- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -----Oorspronkelijk bericht----- Van: Egor Egorov [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 20 juni 2002 15:53 Aan: [EMAIL PROTECTED] Onderwerp: Re: update syntax RBRoa, Thursday, June 20, 2002, 8:07:54 AM, you wrote: R> Is it possible to include another table in [where clause] using the update R> syntax in MySQL?.. R> e.g R> update xtran set f="X" where switch.rc=xtran.rc; R> something like this...a two tables involved in the update but one table only R> to modify... Using only MySQL nope. R> R.B.Roa -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 --------------------------------------------------------------------- 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
