|Subject:||Re: SQL Update Error
|Date:||Sun, 20 Aug 2017 10:19:35 +1000
|From:||Bernie van't Hof <firstname.lastname@example.org>
Consider using a join. Something like (for MySQL, others slightly different)
UPDATE `Tbl1` `t1`
JOIN `Tble2` `t2`
ON `Tbl1`.`Colx` = `t2`.`colx`
SET `t1`.`Coly` = `t2`.`Coly`
On 20/8/17 6:14 am, Mark Bannister wrote:
> 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