I feel like this must be at least somewhat common, but I can't get the wording right to google it. I have two tables with 2 key fields and one data field. From one table to the other, I'd like to update the data field if the keys exist and append the record if it doesn't. I could use query(s) builder or SQL. Example:
Temp table:
Key1 Key2 Data
1 2 Hi
4 3 Hello
Main table:
Key1 Key2 Data
1 2 Hola
4 5 Tag
After update:
Main table:
Key1 Key2 Data
1 2 Hi
4 3 Hello
4 5 Tag