Skip to content
Advertisement

UPDATE VALUES OF COLUMN IN POSTGRESQL

I have 4 tables:

what i want is to update table1 with the salary values from matchsal table with conditions in the others tables, i tried this query:

and i got this error: ERROR: more than one row returned by a subquery used as an expression SQL state: 21000

Advertisement

Answer

I found the answer ^^” It is simple thing

I Just add a limit to the sub query

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