Skip to content
Advertisement

update join with where

I need to update a certain alert on a loan where the obligor and obligation is something, but I can’t figure out what I’m doing wrong in the join. This seems to update all alerts in the table rather than the specific one I want. We are using postgresql db

Advertisement

Answer

Workbench usually refers to MySQL. If so, then the correct syntax is:

In Postgres, this would look like:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement