It works now, thanks! P.P.
> From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Sat, 19 Apr 2008 08:43:42 -0400 > Subject: Re: [sqlite] EXISTS operator doesn't seem to work > > > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Vuoi diventare il numero 1 della community? Scarica il gadget! http://votalospaces.spaces.live.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
