Delete record from a JOINed recordset?

Xojo 2019r1.1 Sqlite DB

What happens if I generate a recordset using an INNER JOIN statement and I then subsequently use recordset.DeleteRecord ?? (Or .Edit / .Update - for that matter…)

it depends on the option “on delete” you stated when you created the foreign key.

Thanks Jean-Yves, I get it now.