X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 27DF09DCC7B for ; Wed, 8 Feb 2006 17:31:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59393-02 for ; Wed, 8 Feb 2006 17:31:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from nelson.osl.com (216-21-133-120.ip.van.radiant.net [216.21.133.120]) by postgresql.org (Postfix) with ESMTP id 8033E9DCC70 for ; Wed, 8 Feb 2006 17:31:47 -0400 (AST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Subject: Re: Non Matching Records in Two Tables Date: Wed, 8 Feb 2006 13:31:48 -0800 Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC20CD3C@nelson.osl.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Non Matching Records in Two Tables Thread-Index: AcYs9MTbQ+73e5ltR0akPu3sxaD2cwAAP/1g From: "Owen Jacobson" To: , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.106 required=5 tests=[AWL=0.106] X-Spam-Score: 0.106 X-Spam-Level: X-Archive-Number: 200602/86 X-Sequence-Number: 24096 S2VuIEhpbGwgd3JvdGU6DQoNCj4gSSBuZWVkIHNvbWUgaGVscCB3aXRoIGEgYml0IG9mIFNRTC4g SSBoYXZlIHR3byB0YWJsZXMuIEkgd2FudA0KPiB0byBmaW5kIHJlY29yZHMgaW4gb25lIHRhYmxl IHRoYXQgZG9uJ3QgbWF0Y2ggcmVjb3JkcyBpbiBhbm90aGVyDQo+IHRhYmxlIGJhc2VkIG9uIGEg Y29tbW9uIGNvbHVtbiBpbiB0aGUgdHdvIHRhYmxlcy4gQm90aCB0YWJsZXMNCj4gaGF2ZSBhIGNv bHVtbiBuYW1lZCAna2V5MTAwJy4gSSB3YXMgdHJ5aW5nIHNvbWV0aGluZyBsaWtlOg0KPiANCj4g U0VMRUNUIGNvdW50KCopDQo+IEZST00gdGFibGUxLCB0YWJsZTINCj4gV0hFUkUgKHRhYmxlMS5r ZXkxMDAgIT0gdGFibGUyLmtleTEwMCk7DQo+IA0KPiBCdXQgdGhlIHF1ZXJ5IGlzIHZlcnkgc2xv dyBhbmQgSSBmaW5hbGx5IGp1c3QgY2FuY2VsIGl0LiBBbnkgaGVscA0KPiBpcyB2ZXJ5IG11Y2gg YXBwcmVjaWF0ZWQuDQoNClRoYXQncyBhIGNhcnRlc2lhbiBqb2luLCB0aGVyZSwgYW5kIGl0J2xs IGJlIGh1Z2UgKG9uIHRoZSBvcmRlciBvZiBOKk0gcm93cywgd2hlcmUgTiBhbmQgTSBhcmUgdGhl IG51bWJlciBvZiByb3dzIGluIHRoZSBmaXJzdCBhbmQgc2Vjb25kIHRhYmxlcyByZXNwZWN0aXZl bHkpLg0KDQpJdCBzb3VuZHMgbGlrZSwgZnJvbSB5b3VyIGRlc2NyaXB0aW9uLCB5b3Ugd2FudCB0 byBmaW5kIHJvd3MgaW4gdGFibGUxIHRoYXQgZG9uJ3QgaGF2ZSBhIGNvcnJlc3BvbmRpbmcgcm93 IGluIHRhYmxlMi4gIFRoaXMgc2hvdWxkIHdvcms6DQoNClNFTEVDVCBjb3VudCgqKQ0KICBGUk9N IHRhYmxlMSBMRUZUIEpPSU4gdGFibGUyIE9OIHRhYmxlMS5rZXkxMDAgPSB0YWJsZTIua2V5MTAw DQogIFdIRVJFIHRhYmxlMi5rZXkxMDAgSVMgTlVMTDsNCg0KVGhpcyB3aWxsIHN0aWxsIGJlIGZh aXJseSBzbG93IHVubGVzcyB0aGVyZSBhcmUgaW5kZXhlcyBvbiB0YWJsZTEua2V5MTAwIGFuZCB0 YWJsZTIua2V5MTAwLCBidXQgbm93aGVyZSBuZWFyIGFzIHNsb3cgYXMgdGhlIG9yaWdpbmFsIHF1 ZXJ5Lg0KDQpGcmFuayBCYXgncyBzb2x1dGlvbiB3aWxsIHdvcmsgaWYgd2hhdCB5b3Ugd2FudCBp cyBhIGNvdW50IG9mIHJvd3MgaW4gdGFibGUxIHRoYXQgZG9uJ3QgaGF2ZSBhIGNvcnJlc3BvbmRp bmcgcm93IGluIHRhYmxlMiBvciBpbiB0YWJsZTIgdGhhdCBkb24ndCBoYXZlIGEgY29ycmVzcG9u ZGluZyByb3cgaW4gdGFibGUxOyBmb3IgdGhhdCBzcGVjaWZpYyByZXF1aXJlbWVudCB5b3UgbWF5 IGFjdHVhbGx5IGJlIGJldHRlciBvZmYgZG9pbmcgdHdvIHF1ZXJpZXMgKG9uZSBmb3IgZWFjaCB0 YWJsZSkgYW5kIGFkZGluZyB0aGUgcmVzdWx0cyB0b2dldGhlci4NCg0KLU93ZW4NCg==