Why does this SQL:



update clients c1

set c1.client_id =

(select min(c2.client_id) from clients c2

where (c2.firstname = c1.firstname) and

(c2.middlename = c1.middlename) and

(c2.lastname = c1.lastname))



Tell me "Validation error for column client_id value "***null***"



There are no nulls in that column.



Note: This is data pumped over from an Access table which, I just found out,
uses multiple id vals for the same client (a client's first record has ID
331, next one is 594, etc. IOW it's just a counter/generator-type value). I,
of course, want the client to have one and only one client_id value.



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]