Subquery trouble :)
| From: | Andreas Cahen | Date: | Tue, 13 May 2003 21:01:29 +0000 |
| Subject: | Subquery trouble :) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27719@lists.php.net to get a copy of this message | ||
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