From: Rick James
Date: August 22 2012 3:47pm
Subject: RE: help with correlated subquery
List-Archive: http://lists.mysql.com/mysql/228051
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148A047A7F@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

VGhlIGlubmVyIHF1ZXJ5IGhhcyBtdWx0aXBsZSByb3dzIGJlY2F1c2Ugb2Ygd2FmZXJfaWQuICBU
aGUgb3V0ZXIgcXVlcnkgdGhlbiBnaXZlcyB5b3UgbXVsdGlwbGUgY29waWVzLCBoZW5jZSBzY3Jl
d2luZyB1cCB0aGUgQ09VTlQuDQoNCkFsc28sIHRoZSBBVkcoQVZHKCkpIGlzIG1hdGhlbWF0aWNh
bGx5IGluY29ycmVjdCB1bmxlc3MgdGhlIGNvdW50cyBhcmUgaWRlbnRpY2FsLg0KDQo+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IExhcnJ5IE1hcnRlbGwgW21haWx0bzpsYXJy
eS5tYXJ0ZWxsQGdtYWlsLmNvbV0NCj4gU2VudDogVHVlc2RheSwgQXVndXN0IDIxLCAyMDEyIDc6
MjcgUE0NCj4gVG86IGhzdkB0YmJzLm5ldA0KPiBDYzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQo+
IFN1YmplY3Q6IFJlOiBoZWxwIHdpdGggY29ycmVsYXRlZCBzdWJxdWVyeQ0KPiANCj4gT24gVHVl
LCBBdWcgMjEsIDIwMTIgYXQgODowNyBQTSwgIDxoc3ZAdGJicy5uZXQ+IHdyb3RlOg0KPiA+Pj4+
PiAyMDEyLzA4LzIxIDE2OjM1IC0wNjAwLCBMYXJyeSBNYXJ0ZWxsID4+Pj4NCj4gPiBJIGFtIHRy
eWluZyB0byB3cml0ZSBhIHF1ZXJ5IHRoYXQgc2VsZWN0cyBmcm9tIGJvdGggYSBjb3JyZWxhdGVk
DQo+ID4gc3VicXVlcnkgYW5kIGEgdGFibGUgaW4gdGhlIG1haW4gcXVlcnksIGFuZCBJJ20gaGF2
aW5nIGEgbG90IG9mDQo+ID4gdHJvdWJsZSBnZXR0aW5nIHRoZSBwcm9wZXIgcm93IGNvdW50LiBJ
J20gc3VyZSB0aGlzIGlzIHZlcnkgc2ltcGxlLA0KPiA+IGFuZCBJJ20ganVzdCBtaXNzaW5nIGl0
LiBJJ2xsIHRyeSBhbmQgcHJlc2VudCBhIHNpbXBsZSBleGFtcGxlLiBGb3INCj4gPiB0aGlzIGV4
YW1wbGUsIHRoZXJlIGFyZSAyNyByb3dzLCBvcmdhbml6ZWQgbGlrZSB0aGlzOg0KPiA+DQo+ID4N
Cj4gPiBteXNxbD4gc2VsZWN0IGNvdW50KCopLCB0YXJnZXRfbmFtZV9pZCwgZXAsIHdhZmVyX2lk
IGZyb20gZGF0YV9jc3QNCj4gPiB3aGVyZSB0YXJnZXRfbmFtZV9pZCA9IDQ0IGdyb3VwIGJ5IHRh
cmdldF9uYW1lX2lkLCBlcCwgd2FmZXJfaWQ7DQo+ID4gKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t
LS0tLSstLS0tLS0rLS0tLS0tLS0tLSsNCj4gPiB8IGNvdW50KCopIHwgdGFyZ2V0X25hbWVfaWQg
fCBlcCAgIHwgd2FmZXJfaWQgfA0KPiA+ICstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rLS0t
LS0tKy0tLS0tLS0tLS0rDQo+ID4gfCAgICAgICAgNiB8ICAgICAgICAgICAgIDQ0IHwgMSwxICB8
ICAgICAgIDE2IHwNCj4gPiB8ICAgICAgICAzIHwgICAgICAgICAgICAgNDQgfCAxLDEgIHwgICAg
ICAgMTcgfA0KPiA+IHwgICAgICAgIDYgfCAgICAgICAgICAgICA0NCB8IDEsMiAgfCAgICAgICAx
NiB8DQo+ID4gfCAgICAgICAgMyB8ICAgICAgICAgICAgIDQ0IHwgMSwyICB8ICAgICAgIDE3IHwN
Cj4gPiB8ICAgICAgICA2IHwgICAgICAgICAgICAgNDQgfCAxLDMgIHwgICAgICAgMTYgfA0KPiA+
IHwgICAgICAgIDMgfCAgICAgICAgICAgICA0NCB8IDEsMyAgfCAgICAgICAxNyB8DQo+ID4gKy0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLSsNCj4gPiA2IHJvd3Mg
aW4gc2V0ICgwLjAwIHNlYykNCj4gPg0KPiA+IEkgbmVlZCB0byBnZXQgYW4gYXZlcmFnZSBvZiBh
IGNvbHVtbiBncm91cGVkIGJ5IHRhcmdldF9uYW1lX2lkLCBlcCBhcw0KPiA+IHdlbGwgYXMgdGhl
IGF2ZXJhZ2Ugb2YgdGhlIGF2ZXJhZ2VzIGdyb3VwZWQgYnkgdGFyZ2V0X25hbWVfaWQsIGVwLA0K
PiA+IHdhZmVyX2lkLCBhbmQgSSBhbHNvIG5lZWQgdGhlIGNvdW50IG9mIHRoZSByb3dzIGluIHRo
ZQ0KPiB0YXJnZXRfbmFtZV9pZCwNCj4gPiBlcCBncm91cC4gTXkgcXVlcnkgaXMgZ2V0dGluZyB0
aGUgY29ycmVjdCBhdmVyYWdlcywgYnV0IGluY29ycmVjdCByb3cNCj4gPiBjb3VudHM6DQo+ID4N
Cj4gPiBteXNxbD4gc2VsZWN0IGNvdW50KCopLCB0YXJnZXRfbmFtZV9pZCwgZXAsIGF2Zyhib3R0
b20pLA0KPiBhdmcoYXZlcmFnZXMpDQo+ID4gZnJvbSAoc2VsZWN0IGF2Zyhib3R0b20pIGFzIGF2
ZXJhZ2VzLCB0YXJnZXRfbmFtZV9pZCBhcyB0LCBlcCBhcyBlDQo+ID4gZnJvbSBkYXRhX2NzdCB3
aGVyZSB0YXJnZXRfbmFtZV9pZCA9IDQ0IGdyb3VwIGJ5IHRhcmdldF9uYW1lX2lkLCBlcCwNCj4g
PiB3YWZlcl9pZCkgeCwgZGF0YV9jc3Qgd2hlcmUgdGFyZ2V0X25hbWVfaWQgPSB0IGFuZCBlcCA9
IGUgZ3JvdXAgYnkNCj4gPiB0YXJnZXRfbmFtZV9pZCwgZXA7DQo+ID4gKy0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLSsNCj4g
PiB8IGNvdW50KCopIHwgdGFyZ2V0X25hbWVfaWQgfCBlcCAgIHwgYXZnKGJvdHRvbSkgfCBhdmco
YXZlcmFnZXMpICAgfA0KPiA+ICstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tKy0t
LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rDQo+ID4gfCAgICAgICAxOCB8ICAgICAgICAg
ICAgIDQ0IHwgMSwxICB8ICAyMS44MDU2NjY3IHwgIDIxLjg1NDU4MzMwMDAwIHwNCj4gPiB8ICAg
ICAgIDE4IHwgICAgICAgICAgICAgNDQgfCAxLDIgIHwgMTIxLjc5ODQ0NDQgfCAxMjEuODM5ODMz
MzUwMDAgfA0KPiA+IHwgICAgICAgMTggfCAgICAgICAgICAgICA0NCB8IDEsMyAgfCAzNDkuNzYz
NDQ0NCB8IDM0OS43NTAxNjY2NTAwMCB8DQo+ID4gKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLSsNCj4gPiAzIHJvd3MgaW4g
c2V0ICgwLjAxIHNlYykNCj4gPg0KPiA+IFRoZSBjb3VudCBmb3IgZWFjaCByb3cgc2hvdWxkIGJl
IDkuIFdoYXQgZG8gSSBuZWVkIGluIG15IGNvdW50KCkgdG8NCj4gYmUNCj4gPiBjb3VudGluZyB0
aGUgcmlnaHQgdGhpbmc/DQo+ID4gPDw8PDw8PDwNCj4gPiBZb3VyIHRyb3VibGUgbHlzIGluIHRo
ZSBqb2luaW5nOyBpbiBlZmZlY3QsIHlvdSBhcmUgam9pbmluZyBhIHJvdw0KPiB3aXRoIHdhZmVy
X2lkIDE2IHdpdGggYSByb3cgd2l0aCB3YWZlcl9pZCAxNywgYW5kIGFsc28gYSByb3cgd2l0aA0K
PiB3YWZlcl9pZCAxNyB3aXRoIGEgcm93IHdpdGggd2FmZXJfaWQgMTYuDQo+ID4NCj4gPiBBIGZ1
cnRoZXIgYWR2YW50YWdlIHRvIHVzaW5nIHRoZSBub3cgc3RhbmRhcmQgZm9ybSBvZiBqb2luaW5n
LCBhcw0KPiBSaWNrIEphbWVzIGJpZHMgeW91IGRvLCBpcyB0aGF0IG9uZSBjYW4gYWRkIGZ1cnRo
ZXIgY29uZGl0aW9ucyB0byBpdDoNCj4gPg0KPiA+IHNlbGVjdCBjb3VudCgqKSwgdGFyZ2V0X25h
bWVfaWQsIGVwLCBhdmcoYm90dG9tKSwgYXZnKGF2ZXJhZ2VzKSBmcm9tDQo+ID4gKHNlbGVjdCBh
dmcoYm90dG9tKSBhcyBhdmVyYWdlcywgdGFyZ2V0X25hbWVfaWQsIGVwDQo+ID4gICAgICAgICBm
cm9tIGRhdGFfY3N0DQo+ID4gICAgICAgICB3aGVyZSB0YXJnZXRfbmFtZV9pZCA9IDQ0DQo+ID4g
ICAgICAgICBncm91cCBieSB0YXJnZXRfbmFtZV9pZCwgZXAsIHdhZmVyX2lkKSB4IEpPSU4gZGF0
YV9jc3QgT04NCj4gPiB0YXJnZXRfbmFtZV9pZCA9IHgudGFyZ2V0X25hbWVfaWQgYW5kIGVwID0g
eC5lcCBhbmQgd2FmZXJfaWQgPA0KPiA+IHgud2FmZXJfaWQgZ3JvdXAgYnkgdGFyZ2V0X25hbWVf
aWQsIGVwDQo+ID4NCj4gPiBUaGUgaW5lcXVhbGl0eSwgbWF5YmUsIHdpbGwgZ2l2ZSB5b3Ugd2hh
dCB5b3Ugd2FudC4NCj4gDQo+IE5vdCwgd2FmZXJfaWQgPCB4LndhZmVyX2lkLCBidXQgd2FmZXJf
aWQgPSB4LndhZmVyX2lkIC0gYWRkaW5nIHRoYXQNCj4gbWFrZXMgaXQgd29yayB0aGUgd2F5IEkg
d2FudC4gVGhhbmtzISENCj4gDQo+IC0tDQo+IE15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0DQo+
IEZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQo+IFRvIHVu
c3Vic2NyaWJlOiAgICBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQoNCg==