[sqlite] Trigger, fetch matching rows and process/insert each row into multiple tables?

[Simon Slavin]

On 24 Sep 2015, at 11:38am, Daniel Polski <daniel at agelektronik.se> wrote:

> -- Here is where my real question starts. Can I fetch a list of rows in a 
> trigger
> -- and update different tables from that data?

Create a VIEW which does this

SELECT ... FROM t1 JOIN t2 ON t2.t1_id = t1.id

Then set the triggers for the VIEW rather than either of the tables.

Simon.