Skip to content
Advertisement

Update join on postgresql – Relation does not exist

I’m using DBeaver as a DBMS, and trying to update a table based on a join:

So what i’m trying to do is update the table conformed_block_names based on a join between this table and table pathwayslist_csv

However, I keep getting the error “ERROR: relation “cbn” does not exist”

I’ve tried restructuring the update in many different ways, but I’m not getting anywhere with it

Advertisement

Answer

This should work:

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