RE: SQL UPDATE of SELECTed records

["Bruce Guetzkow" <bruceg@xxxxxxxxxxxxxxxxxxxxxxx>]

Steve:

I believe you are missing the word "exists", as in the following...

UPDATE library/file
SET field = 'U'
WHERE exists
(SELECT fields
FROM library/file
WHERE conditions)

This indicates that the only records that you want updated are those
that "exist" in the subquery.  Normally your "conditions" would include
some link between the file being updated and the file in the subquery
(a.field = b.field).

Hope that helps,
--Bruce Guetzkow