Updating some rows in tab1 with corresponding values from tab2, pgsql style:
UPDATE tab1
SET value=T2.VALUE
FROM tab2 T2
WHERE T2.restr=1
AND tab1.key=T2.key <<<<<<
The same for MSSQL:
UPDATE tab1
SET value=T2.VALUE
FROM tab1 T1
JOIN tab2 T2 ON T1.key=T2.Key <<<<<<
WHERE T2.restr=1
I'm looking for a portable query style, without using a subquery in the
SET clause (which could make things quite slow)
Any hints?
Regards,
Andreas