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

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C02322.928C43A0
Content-Type: text/plain;

        charset="gb2312"
Content-Transfer-Encoding: base64

UkU6IG5lZWQgc3VndWVzdGlvbnMgYWJvdXQgY2x1c3RlciBzb2Z0d2FyZWhlbGxvICBldmVyYm9k eSAsDQogDQppIGhhdmUgZ290IGEgdGFibGUgbGlrZSB0aGlzLg0KDQpDUkVBVEUgIFRBQkxFIEVN UCANCiggIEVNUF9JRCBOVU1CRVIoMiksDQogICBNQU5BR0VSX0lEICBOVU1CRVIoMiksDQogICBO QU1FICBWQVJDSEFSMigxMCkNCikNCg0KQUxURVIgVEFCTEUgRU1QICBBREQgQ09OU1RSQUlOVCBQ S19FTVAgIFBSSU1BUlkgS0VZIChFTVBfSUQpDQoNCkFMVEVSIFRBQkxFICAgICAgRE9FQklNLkVN UCBBREQgICBDT05TVFJBSU5UIEZLX0VNUF9TRUxGDQpGT1JFSUdOIEtFWSAgICAgIChNQU5BR0VS X0lEICkgICBSRUZFUkVOQ0VTICAgICAgIERPRUJJTS5FTVAgIChFTVBfSUQgKQ0KDQoNCmFuZCBp IGhhdmUgc29tZSByZWNvcmRzIGxpa2UgYmVsbG93DQogICANCiAgIGVtcF9pZCAgIG1hbmFnZXJf aWQgICAgbmFtZSANCiAgIC0tLS0tLS0tLS0tICAgLS0tLS0tLS0tLS0tLS0tLSAgICAtLS0tLS0t LS0tDQogICAgICAxICAgICAgICAgICAgICAxICAgICAgICAgICAgICBhbGkNCiAgICAgIDIgICAg ICAgICAgICAgICAxICAgICAgICAgICAgIHZlbGkNCiAgICAgIDMgICAgICAgICAgICAgIDEgICAg ICAgICAgICAgIGtpcmtkb2t1eg0KICAgICAgNCAgICAgICAgICAgICAgIDEgICAgICAgICAgICAg ZWxsaQ0KICAgICAgNSAgICAgICAgICAgICAgIDUgICAgICAgICAgICAgY3VuZXl0DQogICAgICA2 ICAgICAgICAgICAgICAgNSAgICAgICAgICAgICBhcmtpbg0KICAgICAgNyAgICAgICAgICAgICAg IDUgICAgICAgICAgICAga2VtYWwNCiAgICAgIDggICAgICAgICAgICAgICA1ICAgICAgICAgICAg IHN1bmFsDQoNCiAgaG93IGNhbiAgbWFuYWdlcl9pZCAgY29sdW1uICAgYmUgIHVwZGF0ZWQgICB3 aGVuICBlbXBfaWQgY2hhbmVkIC5mb3IgZXhhbXBsZQ0KICB3aGVuICAgICAidXBkYXRlIGVtcF9p ZCA9IDEwIHdoZXJlIG5hbWUgPSBhbGkgIiAgIHN0YXRtZW50ICBpcyBpc3N1ZWQgLCBob3cgY2Fu IHVwZGF0ZSBvdGhlcg0KICBjb2x1bW5zIHdoaWNoIGNvbnRhaW4gICAxIC4NCg0KICB0aGFuayB5 b3UgZm9yIGhlbHBzLg0KDQoNCg0KDQogIA0KDQoNCg0KICANCg==

------=_NextPart_000_0008_01C02322.928C43A0
Content-Type: text/html;

        charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPjxUSVRMRT5SRTogbmVlZCBzdWd1ZXN0aW9ucyBhYm91dCBjbHVz dGVyIHNvZnR3YXJlPC9USVRMRT4NCjxNRVRBIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD13 aW5kb3dzLTEyNTQiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNI VE1MIDUuMDAuMjkxOS42MzA3IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWT4NCjxESVY+ PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiANCmNsYXNzPTQ5MDMw MjcyMy0yMDA5MjAwMD5oZWxsbyZuYnNwOyBldmVyYm9keSAsPC9TUEFOPjwvRk9OVD48L0RJVj4N CjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiANCmNsYXNz PTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDs8L1NQQU4+PC9GT05UPjwvRElWPg0KPERJVj48Rk9O VCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIGNsYXNzPTQ5MDMwMjcyMy0y MDA5MjAwMD5pIGhhdmUgDQpnb3QgYSB0YWJsZSBsaWtlIHRoaXMuPC9TUEFOPjwvRk9OVD48L0RJ Vj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiANCmNs YXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD48L1NQQU4+PC9GT05UPiZuYnNwOzwvRElWPg0KPERJVj48 Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIA0KY2xhc3M9NDkwMzAy NzIzLTIwMDkyMDAwPkNSRUFURSZuYnNwOyBUQUJMRSBFTVAgPEJSPigmbmJzcDsgRU1QX0lEIA0K TlVNQkVSKDIpLDxCUj4mbmJzcDsmbmJzcDsgTUFOQUdFUl9JRCZuYnNwOyBOVU1CRVIoMiksPEJS PiZuYnNwOyZuYnNwOyANCk5BTUUmbmJzcDsgVkFSQ0hBUjIoMTApPEJSPik8L1NQQU4+PC9GT05U PjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNl PUFyaWFsIHNpemU9Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+QUxURVIgDQpUQUJM RSBFTVAmbmJzcDsgQUREIENPTlNUUkFJTlQgUEtfRU1QJm5ic3A7IFBSSU1BUlkgS0VZIA0KKEVN UF9JRCk8L1NQQU4+PC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQg Y29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAw OTIwMDA+QUxURVIgDQpUQUJMRSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBET0VCSU0u RU1QIEFERCZuYnNwOyZuYnNwOyBDT05TVFJBSU5UIA0KRktfRU1QX1NFTEY8QlI+Rk9SRUlHTiBL RVkmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgKE1BTkFHRVJfSUQgDQopJm5ic3A7Jm5i c3A7IFJFRkVSRU5DRVMmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgRE9FQklN LkVNUCZuYnNwOyANCihFTVBfSUQgKTwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFy aWFsIHNpemU9Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+YW5kIGkgDQpoYXZlIHNv bWUgcmVjb3JkcyBsaWtlIGJlbGxvdzwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNv bG9yPSMwMDAwZmYgZmFjZT1BcmlhbCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3MjMtMjAw OTIwMDA+Jm5ic3A7Jm5ic3A7IDwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9y PSMwMDAwZmYgZmFjZT1BcmlhbCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3MjMtMjAwOTIw MDA+Jm5ic3A7Jm5ic3A7IGVtcF9pZCZuYnNwOyZuYnNwOyANCm1hbmFnZXJfaWQmbmJzcDsmbmJz cDsmbmJzcDsgbmFtZSA8L1NQQU4+PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAw MGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIA0KY2xhc3M9NDkwMzAyNzIzLTIwMDkyMDAwPiZu YnNwOyZuYnNwOyAtLS0tLS0tLS0tLSZuYnNwOyZuYnNwOyANCi0tLS0tLS0tLS0tLS0tLS0mbmJz cDsmbmJzcDsmbmJzcDsgLS0tLS0tLS0tLTwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05U IGNvbG9yPSMwMDAwZmYgZmFjZT1BcmlhbCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3MjMt MjAwOTIwMDA+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KMSZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyANCjEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQphbGk8L1NQQU4+PC9GT05UPjwvRElW Pg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIA0KY2xh c3M9NDkwMzAyNzIzLTIwMDkyMDAwPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjIm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQoxJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KdmVsaTwvU1BB Tj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9yPSMwMDAwZmYgZmFjZT1BcmlhbCBzaXpl PTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7IA0KMyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjEmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQpraXJrZG9rdXo8L1NQQU4+PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAw MGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIA0KY2xhc3M9NDkwMzAyNzIzLTIwMDkyMDAwPiZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCjQmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQoxJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KZWxsaTwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxG T05UIGNvbG9yPSMwMDAwZmYgZmFjZT1BcmlhbCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3 MjMtMjAwOTIwMDA+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KNSZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyANCjUmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQpjdW5leXQ8L1NQQU4+PC9GT05U PjwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFO IA0KY2xhc3M9NDkwMzAyNzIzLTIwMDkyMDAwPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyANCjYmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQo1Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KYXJr aW48L1NQQU4+PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJp YWwgc2l6ZT0yPjxTUEFOIA0KY2xhc3M9NDkwMzAyNzIzLTIwMDkyMDAwPiZuYnNwOzwvU1BBTj48 L0ZPTlQ+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIA0Kc2l6ZT0yPjxTUEFOIGNsYXNz PTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQo3Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KNSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO2tlbWFsPC9TUEFOPjwv Rk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48 U1BBTiANCmNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgDQo4Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7NSZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyANCnN1bmFsPC9TUEFOPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBm YWNlPUFyaWFsIHNpemU9Mj48U1BBTiANCmNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD48L1NQQU4+ PC9GT05UPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwg c2l6ZT0yPjxTUEFOIGNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDsgDQpob3cgY2FuJm5i c3A7IG1hbmFnZXJfaWQmbmJzcDsgY29sdW1uJm5ic3A7Jm5ic3A7IGJlJm5ic3A7IHVwZGF0ZWQm bmJzcDsmbmJzcDsgDQp3aGVuJm5ic3A7IGVtcF9pZCBjaGFuZWQgLmZvciBleGFtcGxlPC9TUEFO PjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9 Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+Jm5ic3A7IA0Kd2hlbiZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyAidXBkYXRlIGVtcF9pZCA9IDEwIHdoZXJlIG5hbWUgPSBhbGkgIiZuYnNw OyZuYnNwOyANCnN0YXRtZW50Jm5ic3A7IGlzIGlzc3VlZCAsIGhvdyBjYW4gdXBkYXRlIG90aGVy PC9TUEFOPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFs IHNpemU9Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+Jm5ic3A7IA0KY29sdW1ucyB3 aGljaCBjb250YWluJm5ic3A7Jm5ic3A7IDEgLjwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPiZu YnNwOzwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxT UEFOIGNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDsgDQp0aGFuayB5b3UgZm9yIGhlbHBz LjwvU1BBTj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9yPSMwMDAwZmYgZmFjZT1Bcmlh bCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+PC9TUEFOPjwvRk9OVD4m bmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48 U1BBTiANCmNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD48L1NQQU4+PC9GT05UPiZuYnNwOzwvRElW Pg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0yPjxTUEFOIA0KY2xh c3M9NDkwMzAyNzIzLTIwMDkyMDAwPjwvU1BBTj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxG T05UIGNvbG9yPSMwMDAwZmYgZmFjZT1BcmlhbCBzaXplPTI+PFNQQU4gDQpjbGFzcz00OTAzMDI3 MjMtMjAwOTIwMDA+PC9TUEFOPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9 IzAwMDBmZiBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiBjbGFzcz00OTAzMDI3MjMtMjAwOTIwMDA+ Jm5ic3A7IA0KPC9TUEFOPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBm YWNlPUFyaWFsIHNpemU9Mj48U1BBTiANCmNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD48QlI+PC9T UEFOPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDBmZiBmYWNlPUFy aWFsIHNpemU9Mj48U1BBTiANCmNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD48L1NQQU4+PC9GT05U PiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBjb2xvcj0jMDAwMGZmIGZhY2U9QXJpYWwgc2l6ZT0y PjxTUEFOIGNsYXNzPTQ5MDMwMjcyMy0yMDA5MjAwMD4mbmJzcDsgDQo8L1NQQU4+PC9GT05UPjwv Received on Wed Sep 20 2000 - 18:48:16 CDT