Yes, that did the trick. Thanks.
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> UPDATE accomodation
> SET country = (
> SELECT c.country
> FROM country c
> WHERE c.country_id = accomodation.country_id
> );
>
> Igor Tandetnik
>
>
__
Do
Joe Wilson wrote:
It results in a error - it stops parsing the statement at the alias
'a'. It seems simple, but I don't believe it is possible to do this
in SQLite. I've tried a dozen common syntax variants used by other
databases without success.
Try
UPDATE accomodation
SET country = (
SELE
It results in a error - it stops parsing the statement at the alias 'a'. It
seems simple, but I
don't believe it is possible to do this in SQLite. I've tried a dozen common
syntax variants used
by other databases without success.
Here is the syntax of the SQLite UPDATE statement:
sql-statement
Joe Wilson wrote:
Does anyone know how I might accomplish this in SQLite using a single
update statement?
-- MySQL
UPDATE accomodation a, country c
SET a.country = c.country
WHERE a.country_id = c.country_id;
-- Oracle
UPDATE accomodation a
SET a.country = (
SELECT c.country
FROM country c
4 matches
Mail list logo
