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]

Reply via email to