From: esquel@sommarskog.se   
      
   Anton Shepelev (anton.txt@g{oogle}mail.com) writes:   
   > Question withdrawn. It was an error in my logic, whereas   
   > the syntax is quite clear. The simplest UPDATED from another   
   > table does *not* requre that it the table begin updated be   
   > mentioned in the FROM clause:   
   >   
   >   UPDATE upd_tab   
   >   SET col = data_tab.col   
   >   FROM data_tab   
   >   WHERE data_tab.code = upd_tab.code   
   >   
      
   Whereas this is legal and produces something, I definitely recommend   
   against it. I will have to admit that I don't understand what this is   
   doing - and I certainly play an SQL expert on TV.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)