UPDATE tableA A1
SET A1.col1 =
FROM tableA A2, tableB B1
WHERE A2.col3 = B1.col1 AND (few MORE conditions)
AND A2.col2 = A1.col2)
A1.col3 IN (SOME MORE conditions)
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
16 People are following this question.
New to SQL I need help on this query in postgress
SQL query problem: Only first 3 active affiliate commision out of 10000 recruits is calculated and only for first 3 sales from each recruits?
SQL Logic issue
How to compare same column values rows?
I want to compare row to row for each ID in SQL query