Update query - two table-a field different

[diegomarino]

Hi,
as you can see in the db i have two tables

1) iscrittiOCf


2) iscrittiOcfNuovi

look at the select query, i want to update the records in "iscrittiOcf" table from "iscrittiOcfNuovi" table, with the criteria you can see in the query.
thanksUpdate.zipUpdate.zip

[ranman256]

click the UPDATE button, then fill in the UPDATE TO like:

iscrittiOcf.CAP
updateto:iscrittiOcfNuovi.CAP

do it for every field

[diegomarino]

Thank you very much, i normally make those operations but i use the ID, in this case is not possibile.
I made the query as an update query, but it adds the record instead of updating it. i can't get it

[isladogs]

You have created an UPSERT or UPEND query due to the use of left joins.
This will both UPDATE existing records and APPEND new records. See UpEnd Query (isladogs.co.uk)
To prevent records being appended, use INNER JOINs instead

[diegomarino]

thanks
i made this query, seems to work fine