Hi there list readers! I need some hints on an update statement I want to use for my database and after trying for a while I decided to ask you guys.. This is the troublemaker: UPDATE details_domains_a SET town_id = 910 WHERE Domain IN (SELECT domain FROM domains_a WHERE town_id = 910); The error I get: You have an error in your SQL syntax near 'SELECT domain FROM domains_a WHERE town_id = 910 )' at line 1 The subquery itself, SELECT domain FROM domains_a WHERE town_id = 910, works fine.. Any advises, hints or clues?? :) Cheers, Andreas Cahen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
