[SQL] UPDATE FROM portability

[Andreas Pflug]

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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])