Throws an error if I try using a join.
"Invalid use of keyword.
Line Number: 2
Token: JOIN"

On 8/19/2017 7:19 PM, Bernie van't Hof wrote:
> 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
>>
>>