On Apr 19, 2008, at 7:06 AM, pinco palletto wrote:
> update register
> set note = (select ORT.note from old_register ORT
> where ORT.person_id = person_id and ORT.document_id = document_id)
> where exists (
> select ORT.* from old_register ORT
> where ORT.person_id = person_id and ORT.document_id = document_id);
update register
set note = (select ORT.note from old_register ORT
where ORT.person_id = register.person_id
and ORT.document_id = register.document_id)
where exists (select ORT.* from old_register ORT
where ORT.person_id = register.person_id
and ORT.document_id = register. document_id);
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
