On Tue, May 13, 2003 at 11:40:24PM +0200, Andreas Cahen wrote: > Hi Maxim! > > > 3 questions: > > > 1. what DB is it for? Looks like Oralce to me :) > > 2. What sense can it make updating town_id to 910 on any row that > already contains it? 3. what is this 'Domain'? That could actually be > your syntax error. > > So far... 2 questions :) > > 1. I use mySQL, such subqueries were working the days I used to work > with Oracle, but those days are gone now :) If I'm not mistaken, MySQL started supporting subselects in version 4.0 or 4.1. -- Hans -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php