trying the following expression but get an update according to the first record rather than being conditional on specific records processed:
db.executesql("UPDATE Plant SET SiteID=(SELECT Site.id FROM Plant, Site
WHERE Site.SiteId = Plant.SiteIdLink);")
ie. all SiteID's get the value of the first Site.SiteId = Plant.SiteIdLink
encountered.
Just can't see the solution at present.
