Re: SQL Update with a Join Syntax

UPDATE NameInfo

   SET NameInfo.flag = 'OK'
 WHERE NameInfo.lastname = 'Smith'
   AND EXISTS

       (SELECT *
           FROM AddressInfo AS A1
         WHERE A1.civic_id = NameInfo.civic_id 
           AND A1.town = 'Moncton');

Read the other posting about the proper syntax for an UPDATE. Received on Sun Aug 08 2004 - 01:39:41 CEST