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 :) 2. Let me explain you the structure.. I got 3 tables involved... CREATE TABLE `details_domains_a` ( `ID` int(10) NOT NULL auto_increment, `Domain` varchar(255) NOT NULL default '', . . Lotsa fields :) . . `town_ID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=370 ; CREATE TABLE `domains_a` ( `domain` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `check` int(11) NOT NULL default '0', `check_date` date NOT NULL default '0000-00-00', `town_ID` int(11) NOT NULL default '0', KEY `domain` (`domain`), KEY `name` (`name`) ) TYPE=MyISAM; CREATE TABLE `towns` ( `town_ID` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `check` int(11) NOT NULL default '0', `check_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`town_ID`) ) TYPE=MyISAM AUTO_INCREMENT=4171 ; And I need to do following: UPDATE details_domains_a SET town_id = 910 WHERE Domain IN ( SELECT domain FROM domains_a WHERE town_id = 910 ) Maybe it's just a typo... :( Cheers, Andreas Cahen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
