Re: [sqlite] How to update plural rows from one table to another.

2019-11-15 Thread Keith Medcalf
On Friday, 15 November, 2019 15:22, Gan Uesli Starling wrote: >In the following update query, I had expected for the integer values >"rowid" from the table "info" to project copies of themselves singly and >separately into the integer cells "info_id" of table "qso", row-by-row, >where the

[sqlite] How to update plural rows from one table to another.

2019-11-15 Thread Gan Uesli Starling
In the following update query, I had expected for the integer values "rowid" from the table "info" to project copies of themselves singly and separately into the integer cells "info_id" of table "qso", row-by-row, where the timestamps "t_from" of each are matching. UPDATE qso SET info_id = (