|Subject:||SQL Update Error
|Date:||Sat, 19 Aug 2017 15:14:51 -0500
|From:||Mark Bannister <markRemove@THISinjection-moldings.com>
Jeez, I'm terrible at sql.
I just want to update a table with values from another.
UPDATE ':PRIV:__Sql_run148.db' t1
SET t1.'pph' = (SELECT t2.'PPh'
FROM ':PRIV:__sql_run147.db' t2
WHERE t1.'icn' = t2.'icn'
But I get error "Single row subquery produced more than one row."
Obviously I'm going about this the wrong way. I want multiple rows.
I've got more than one row to update. I actually need to update two
fields but I can't even get past this error.