I think today might have been the first time I had to use update from on the fly on a production system. I’ve previously always used the “missing-from-clause” style syntax, like this:
UPDATE sarbel_ejemplo SET clientele_call = ejemplo.clientele_call WHERE ejemplo_id = ejemplo.ejemplo_id AND ejemplo.valid AND NOT ejemplo.complete;
Of course the new(ish) and fancy way to do such a thing would be:
UPDATE sarbel_ejemplo SET clientele_call = e.clientele_call FROM ejemplo e WHERE e.valid AND NOT e.complete AND sarbel_ejemplo.ejemplo_id= e.ejemplo_id ;
Nothing earth shattering, but a tool every DBA should be familiar with.