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.


--
Mark Bannister