?How to update one table based on another (efficiently)

 I would like to update one table's records based on records in another. Something like:
  UPDATE BatchTable

     SET Marked_Record = 'Y'
   WHERE ColA||ColB||ColC =

         (SELECT ColX||ColY||ColZ
            FROM AnotherTable)

In other words, if AnotherTable has a triplet that matches a triplet that occurs in BatchTable, then set BatchTable.Marked_Record to 'Y'.

I can't see a more efficient way to do this in the SQL Language manual, but it seems like there must be something less brutal! Can anyone give me a tip on this?

Thanks,

.../dave Dave Charlesworth Received on Tue May 04 1993 - 23:26:24 CEST