"Williams, Ken" <[EMAIL PROTECTED]> writes:
> Is it possible in SQLite to update a table using information from another
> table? Something like the "UPDATE ... FROM" syntax in Postgres, or "UPDATE
> table1, table2 ..." syntax in MySQL is what I'm looking for.
>
> If not, can someone suggest a workaround?
How about something like this:
UPDATE table1
SET field23 = (SELECT field42
FROM table2
WHERE condition);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
