[sqlite] Re: updating based on JOIN

[Igor Tandetnik]

P Kishor <[EMAIL PROTECTED]> wrote:

CREATE TABLE zip (zip_code, city);
CREATE TABLE city (city_id, name);

INSERT a bunch of data. Then...

ALTER TABLE zip ADD COLUMN city_id;

UPDATE zip
SET city_id = c.city_id
FROM zip JOIN city c ON zip.city = c.name;

UPDATE zip SET city_id = (
   SELECT city_id FROM city WHERE zip.city = city.name);

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------