From: Jochem van Dieten Date: October 20 2005 7:44am Subject: Re: Multiple INNER JOINS List-Archive: http://lists.mysql.com/mysql/190626 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 T24gMTAvMTkvMDUsIFBldGVyIEJyYXdsZXkgd3JvdGU6Cj4+Cj4+IEkgYW0gaGF2aW5nIHByb2Js ZW1zIHdpdGggdGhlIGZvbGxvd2luZyBxdWVyeTogSSBhbQo+PiB0cnlpbmcgdG8gam9pbiBUYXhf QmFuZHMgYW5kIFByb3BlcnR5X1R5cGVzIHRvIFByb3BlcnRpZXMKPj4gYnV0IHRoZSBxdWVyeSBz ZWVtcyB0byBiZSBqb25pbmcgVGF4X0JhbmRzIHRvIFByb3BlcnRpZXMuCj4KPiBUaGF0IHF1ZXJ5 IGdlbmVyYXRlcyBubyBlcnJvciBpbiA1LjAuMTMuIFRoZXJlIGhhdmUgYmVlbiBzZXZlcmFsIGNh c2NhZGluZwo+IGpvaW4gYnVncywgc29tZSBmaXhlZCwgc29tZSBub3QuIFdoYXQgdmVyc2lvbiBh cmUgeW91IHJ1bm5pbmc/CgpUaGlzIHBhcnRpY3VsYXIgb25lIHdhcyBmaXhlZCBpbiA1LjAuMTIu IFRoZSBmaXggcG9zZXMgYSBzZXJpb3VzCmJhY2t3YXJkIGNvbXBhdGliaWxpdHkgcmlzayBmb3Ig ZXZlcnkgcXVlcnkgdXNpbmcgVVNJTkcgb3IgTkFUVVJBTCwgc28KdW5sZXNzIHlvdSBhcmUgZXhj bHVzaXZlbHkgZGV2ZWxvcGluZyBmb3IgNSBhbmQgaGlnaGVyLCB5b3Ugc2hvdWxkIG5vdAp1c2Ug dGhlbS4KCgpUaGUgc2hvcnRlc3QgZXhwbGFuYXRpb24gb2YgdGhlIHByb2JsZW0gaXMgdG8ganVz dCB0cnkgdGhlIGZvbGxvd2luZyBxdWVyaWVzOgpDUkVBVEUgVEFCTEUgdGVzdCAoSUQgSU5UKTsK SU5TRVJUIElOVE8gdGVzdCAoSUQpIFZBTFVFUyAoMSk7CgpTRUxFQ1QgKiBGUk9NIHRlc3QgdDEg Sk9JTiB0ZXN0IHQyIFVTSU5HIChJRCk7ClNFTEVDVCBJRCBGUk9NIHRlc3QgdDEgSk9JTiB0ZXN0 IHQyIFVTSU5HIChJRCk7ClNFTEVDVCB0MS5JRCBGUk9NIHRlc3QgdDEgSk9JTiB0ZXN0IHQyIFVT SU5HIChJRCk7ClNFTEVDVCB0Mi5JRCBGUk9NIHRlc3QgdDEgSk9JTiB0ZXN0IHQyIFVTSU5HIChJ RCk7CgpTRUxFQ1QgKiBGUk9NIHRlc3QgdDEgTkFUVVJBTCBKT0lOIHRlc3QgdDI7ClNFTEVDVCBJ RCBGUk9NIHRlc3QgdDEgTkFUVVJBTCBKT0lOIHRlc3QgdDI7ClNFTEVDVCB0MS5JRCBGUk9NIHRl c3QgdDEgTkFUVVJBTCBKT0lOIHRlc3QgdDI7ClNFTEVDVCB0Mi5JRCBGUk9NIHRlc3QgdDEgTkFU VVJBTCBKT0lOIHRlc3QgdDI7CgpEUk9QIFRBQkxFIHRlc3Q7CgoKV3JpdGluZyB0aGUgZnVsbCBq b2luIGNvbmRpdGlvbiB3aWxsIGluZGVlZCB3b3JrLgoKSm9jaGVtCg==