I’m trying to update one table from another, and I just can’t get the cockroachdb flavoured syntax correct despite having used many combinations. I apologize in advance for the basic nature of this question, but I’m stumped.
In Postgres, I’d do something like this.
update p set “itemOrder” = profession.“itemOrder” from profession where p.id = profession.id;
but that takes me to this error message
Obviously there’s a simple solution to this problem but it eludes me. Appreciate any advice.