HOW CAN I WRITE A TRIGGER FOR THIS .. --- SELF JOIN

This is a multi-part message in MIME format.

------=_NextPart_000_0002_01C02328.D31C86E0
Content-Type: text/plain;

        charset="windows-1254"
Content-Transfer-Encoding: base64

aGVsbG8gIGV2ZXJib2R5ICwNCiANCmkgaGF2ZSBnb3QgYSB0YWJsZSBsaWtlIHRoaXMuDQogDQpD UkVBVEUgIFRBQkxFIEVNUCANCiggIEVNUF9JRCBOVU1CRVIoMiksDQogICBNQU5BR0VSX0lEICBO VU1CRVIoMiksDQogICBOQU1FICBWQVJDSEFSMigxMCkNCikNCiANCkFMVEVSIFRBQkxFIEVNUCAg QUREIENPTlNUUkFJTlQgUEtfRU1QICBQUklNQVJZIEtFWSAoRU1QX0lEKQ0KIA0KQUxURVIgVEFC TEUgICAgICBET0VCSU0uRU1QIEFERCAgIENPTlNUUkFJTlQgRktfRU1QX1NFTEYNCkZPUkVJR04g S0VZICAgICAgKE1BTkFHRVJfSUQgKSAgIFJFRkVSRU5DRVMgICAgICAgRE9FQklNLkVNUCAgKEVN UF9JRCApDQogDQogDQphbmQgaSBoYXZlIHNvbWUgcmVjb3JkcyBsaWtlIGJlbGxvdw0KICAgDQog ICBlbXBfaWQgICBtYW5hZ2VyX2lkICAgIG5hbWUgDQogICAtLS0tLS0tLS0tLSAgIC0tLS0tLS0t LS0tLS0tLS0gICAgLS0tLS0tLS0tLQ0KICAgICAgMSAgICAgICAgICAgICAgMSAgICAgICAgICAg ICAgYWxpDQogICAgICAyICAgICAgICAgICAgICAgMSAgICAgICAgICAgICB2ZWxpDQogICAgICAz ICAgICAgICAgICAgICAxICAgICAgICAgICAgICBraXJrZG9rdXoNCiAgICAgIDQgICAgICAgICAg ICAgICAxICAgICAgICAgICAgIGVsbGkNCiAgICAgIDUgICAgICAgICAgICAgICA1ICAgICAgICAg ICAgIGN1bmV5dA0KICAgICAgNiAgICAgICAgICAgICAgIDUgICAgICAgICAgICAgYXJraW4NCiAg ICAgIDcgICAgICAgICAgICAgICA1ICAgICAgICAgICAgIGtlbWFsDQogICAgICA4ICAgICAgICAg ICAgICAgNSAgICAgICAgICAgICBzdW5hbA0KIA0KICBob3cgY2FuICBtYW5hZ2VyX2lkICBjb2x1 bW4gICBiZSAgdXBkYXRlZCAgIHdoZW4gIGVtcF9pZCBjaGFuZWQgLmZvciBleGFtcGxlDQogIHdo ZW4gICAgICJ1cGRhdGUgZW1wX2lkID0gMTAgd2hlcmUgbmFtZSA9IGFsaSAiICAgc3RhdG1lbnQg IGlzIGlzc3VlZCAsIGhvdyBjYW4gdXBkYXRlIG90aGVyDQogIGNvbHVtbnMgd2hpY2ggY29udGFp biAgIDEgLg0KIA0KICB0aGFuayB5b3UgZm9yIGhlbHBzLg0KIA0K

------=_NextPart_000_0002_01C02328.D31C86E0
Content-Type: text/html;

        charset="windows-1254"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXdp bmRvd3MtMTI1NCIgaHR0cC1lcXVpdj1Db250ZW50LVR5cGU+DQo8TUVUQSBjb250ZW50PSJNU0hU TUwgNS4wMC4yOTE5LjYzMDciIG5hbWU9R0VORVJBVE9SPjwvSEVBRD4NCjxCT0RZPg0KPERJVj48 Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5oZWxsbyZuYnNwOyBldmVyYm9keSAsPEJSPiZuYnNwOzxC Uj5pIGhhdmUgZ290IGEgDQp0YWJsZSBsaWtlIHRoaXMuPEJSPiZuYnNwOzxCUj5DUkVBVEUmbmJz cDsgVEFCTEUgRU1QIDxCUj4oJm5ic3A7IEVNUF9JRCANCk5VTUJFUigyKSw8QlI+Jm5ic3A7Jm5i c3A7IE1BTkFHRVJfSUQmbmJzcDsgTlVNQkVSKDIpLDxCUj4mbmJzcDsmbmJzcDsgDQpOQU1FJm5i c3A7IFZBUkNIQVIyKDEwKTxCUj4pPEJSPiZuYnNwOzxCUj5BTFRFUiBUQUJMRSBFTVAmbmJzcDsg QUREIENPTlNUUkFJTlQgDQpQS19FTVAmbmJzcDsgUFJJTUFSWSBLRVkgKEVNUF9JRCk8QlI+Jm5i c3A7PEJSPkFMVEVSIA0KVEFCTEUmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgRE9FQklN LkVNUCBBREQmbmJzcDsmbmJzcDsgQ09OU1RSQUlOVCANCkZLX0VNUF9TRUxGPEJSPkZPUkVJR04g S0VZJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IChNQU5BR0VSX0lEIA0KKSZuYnNwOyZu YnNwOyBSRUZFUkVOQ0VTJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IERPRUJJ TS5FTVAmbmJzcDsgDQooRU1QX0lEICk8QlI+Jm5ic3A7PEJSPiZuYnNwOzxCUj5hbmQgaSBoYXZl IHNvbWUgcmVjb3JkcyBsaWtlIA0KYmVsbG93PEJSPiZuYnNwOyZuYnNwOyA8QlI+Jm5ic3A7Jm5i c3A7IGVtcF9pZCZuYnNwOyZuYnNwOyANCm1hbmFnZXJfaWQmbmJzcDsmbmJzcDsmbmJzcDsgbmFt ZSA8QlI+Jm5ic3A7Jm5ic3A7IC0tLS0tLS0tLS0tJm5ic3A7Jm5ic3A7IA0KLS0tLS0tLS0tLS0t LS0tLSZuYnNwOyZuYnNwOyZuYnNwOyAtLS0tLS0tLS0tPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyANCjEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQoxJm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IA0KYWxpPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjImbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsgDQoxJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KdmVsaTxCUj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsgDQozJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KMSZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyANCmtpcmtkb2t1ejxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQo0Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KMSZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCmVs bGk8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KNSZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyANCjUmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQpjdW5leXQ8QlI+Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7IA0KNiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjUmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsgDQphcmtpbjxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQo3Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KNSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCmtlbWFsPEJSPiZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjgmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQo1Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0Kc3VuYWw8QlI+Jm5ic3A7PEJSPiZuYnNwOyBob3cgY2Fu Jm5ic3A7IG1hbmFnZXJfaWQmbmJzcDsgY29sdW1uJm5ic3A7Jm5ic3A7IA0KYmUmbmJzcDsgdXBk YXRlZCZuYnNwOyZuYnNwOyB3aGVuJm5ic3A7IGVtcF9pZCBjaGFuZWQgLmZvciBleGFtcGxlPEJS PiZuYnNwOyANCndoZW4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgInVwZGF0ZSBlbXBfaWQgPSAx MCB3aGVyZSBuYW1lID0gYWxpICImbmJzcDsmbmJzcDsgDQpzdGF0bWVudCZuYnNwOyBpcyBpc3N1 ZWQgLCBob3cgY2FuIHVwZGF0ZSBvdGhlcjxCUj4mbmJzcDsgY29sdW1ucyB3aGljaCANCmNvbnRh aW4mbmJzcDsmbmJzcDsgMSAuPEJSPiZuYnNwOzxCUj4mbmJzcDsgdGhhbmsgeW91IGZvciANCmhl bHBzLjxCUj4mbmJzcDs8L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg== Received on Wed Sep 20 2000 - 19:33:01 CDT