Hi again :-) I have a database with a layout like: create table people ( id, name ); create table phones (id, type, phone);
And my application sends me diffs from other users of the system, where the diffs are another db with the same tables as the main db, but with records which have been modified since I sent out a merged db. The system works well, but I want to know how I can do this: Print a list of people whose phones in the old db are different from the new db. In other words, if a phone was added deleted or changed, I would like to print out the list. Is there a one-query solution? Thanks! -- My GPG public key is at http://ronware.gotdns.com/ fingerprint: 4E91 06E9 2020 114C 8BCD 55B2 0816 60AF 2B3D 4C51 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]