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

c2VsZWN0ICBjb3VudCgqKSwgdGFyZ2V0X25hbWVfaWQsIGVwLCBhdmcoYm90dG9tKSwgYXZnKGF2
ZXJhZ2VzKQ0KICAgIGZyb20gIA0KDQogICAgICAgICggU0VMRUNUICBhdmcoYm90dG9tKSBhcyBh
dmVyYWdlcywgdGFyZ2V0X25hbWVfaWQgYXMgdCwNCiAgICAgICAgICAgICAgICBlcCBhcyBlDQog
ICAgICAgICAgICBmcm9tICBkYXRhX2NzdA0KICAgICAgICAgICAgd2hlcmUgIHRhcmdldF9uYW1l
X2lkID0gNDQNCiAgICAgICAgICAgIGdyb3VwIGJ5ICB0YXJnZXRfbmFtZV9pZCwgZXAsIHdhZmVy
X2lkKSB4LA0KICAgICAgICBkYXRhX2NzdA0KICAgIHdoZXJlICB0YXJnZXRfbmFtZV9pZCA9IHQN
CiAgICAgIGFuZCAgZXAgPSBlDQogICAgZ3JvdXAgYnkgIHRhcmdldF9uYW1lX2lkLCBlcDsNCg0K
UGxlYXNlIHF1YWxpZnkgYWxsIGZpZWxkcyB3aXRoIHRhYmxlIG5hbWVzIChvciBhbGlhc2VzKS4g
IEkgY2FuJ3QgdGVsbCB3aGF0IGVwIGFuZCBlIGFyZS4gIEV0Yy4NCg0KUGxlYXNlIHR1cm4gdGhl
ICJjb21tYWpvaW4iIGludG8gYW4gZXhwbGljaXQgSk9JTi4uLk9OLg0KDQo+IC0tLS0tT3JpZ2lu
YWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IExhcnJ5IE1hcnRlbGwgW21haWx0bzpsYXJyeS5tYXJ0
ZWxsQGdtYWlsLmNvbV0NCj4gU2VudDogVHVlc2RheSwgQXVndXN0IDIxLCAyMDEyIDM6MzUgUE0N
Cj4gVG86IG15c3FsIG1haWxpbmcgbGlzdA0KPiBTdWJqZWN0OiBoZWxwIHdpdGggY29ycmVsYXRl
ZCBzdWJxdWVyeQ0KPiANCj4gSSBhbSB0cnlpbmcgdG8gd3JpdGUgYSBxdWVyeSB0aGF0IHNlbGVj
dHMgZnJvbSBib3RoIGEgY29ycmVsYXRlZA0KPiBzdWJxdWVyeSBhbmQgYSB0YWJsZSBpbiB0aGUg
bWFpbiBxdWVyeSwgYW5kIEknbSBoYXZpbmcgYSBsb3Qgb2YgdHJvdWJsZQ0KPiBnZXR0aW5nIHRo
ZSBwcm9wZXIgcm93IGNvdW50LiBJJ20gc3VyZSB0aGlzIGlzIHZlcnkgc2ltcGxlLCBhbmQgSSdt
DQo+IGp1c3QgbWlzc2luZyBpdC4gSSdsbCB0cnkgYW5kIHByZXNlbnQgYSBzaW1wbGUgZXhhbXBs
ZS4gRm9yIHRoaXMNCj4gZXhhbXBsZSwgdGhlcmUgYXJlIDI3IHJvd3MsIG9yZ2FuaXplZCBsaWtl
IHRoaXM6DQo+IA0KPiANCj4gbXlzcWw+IHNlbGVjdCBjb3VudCgqKSwgdGFyZ2V0X25hbWVfaWQs
IGVwLCB3YWZlcl9pZCBmcm9tIGRhdGFfY3N0DQo+IHdoZXJlIHRhcmdldF9uYW1lX2lkID0gNDQg
Z3JvdXAgYnkgdGFyZ2V0X25hbWVfaWQsIGVwLCB3YWZlcl9pZDsNCj4gKy0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLSsNCj4gfCBjb3VudCgqKSB8IHRhcmdldF9u
YW1lX2lkIHwgZXAgICB8IHdhZmVyX2lkIHwNCj4gKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0rLS0tLS0tLS0tLSsNCj4gfCAgICAgICAgNiB8ICAgICAgICAgICAgIDQ0IHwgMSwx
ICB8ICAgICAgIDE2IHwNCj4gfCAgICAgICAgMyB8ICAgICAgICAgICAgIDQ0IHwgMSwxICB8ICAg
ICAgIDE3IHwNCj4gfCAgICAgICAgNiB8ICAgICAgICAgICAgIDQ0IHwgMSwyICB8ICAgICAgIDE2
IHwNCj4gfCAgICAgICAgMyB8ICAgICAgICAgICAgIDQ0IHwgMSwyICB8ICAgICAgIDE3IHwNCj4g
fCAgICAgICAgNiB8ICAgICAgICAgICAgIDQ0IHwgMSwzICB8ICAgICAgIDE2IHwNCj4gfCAgICAg
ICAgMyB8ICAgICAgICAgICAgIDQ0IHwgMSwzICB8ICAgICAgIDE3IHwNCj4gKy0tLS0tLS0tLS0r
LS0tLS0tLS0tLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLSsNCj4gNiByb3dzIGluIHNldCAoMC4w
MCBzZWMpDQo+IA0KPiBJIG5lZWQgdG8gZ2V0IGFuIGF2ZXJhZ2Ugb2YgYSBjb2x1bW4gZ3JvdXBl
ZCBieSB0YXJnZXRfbmFtZV9pZCwgZXAgYXMNCj4gd2VsbCBhcyB0aGUgYXZlcmFnZSBvZiB0aGUg
YXZlcmFnZXMgZ3JvdXBlZCBieSB0YXJnZXRfbmFtZV9pZCwgZXAsDQo+IHdhZmVyX2lkLCBhbmQg
SSBhbHNvIG5lZWQgdGhlIGNvdW50IG9mIHRoZSByb3dzIGluIHRoZSB0YXJnZXRfbmFtZV9pZCwN
Cj4gZXAgZ3JvdXAuIE15IHF1ZXJ5IGlzIGdldHRpbmcgdGhlIGNvcnJlY3QgYXZlcmFnZXMsIGJ1
dCBpbmNvcnJlY3Qgcm93DQo+IGNvdW50czoNCj4gDQo+IG15c3FsPiBzZWxlY3QgY291bnQoKiks
IHRhcmdldF9uYW1lX2lkLCBlcCwgYXZnKGJvdHRvbSksIGF2ZyhhdmVyYWdlcykNCj4gZnJvbSAo
c2VsZWN0IGF2Zyhib3R0b20pIGFzIGF2ZXJhZ2VzLCB0YXJnZXRfbmFtZV9pZCBhcyB0LCBlcCBh
cyBlIGZyb20NCj4gZGF0YV9jc3Qgd2hlcmUgdGFyZ2V0X25hbWVfaWQgPSA0NCBncm91cCBieSB0
YXJnZXRfbmFtZV9pZCwgZXAsDQo+IHdhZmVyX2lkKSB4LCBkYXRhX2NzdCB3aGVyZSB0YXJnZXRf
bmFtZV9pZCA9IHQgYW5kIGVwID0gZSBncm91cCBieQ0KPiB0YXJnZXRfbmFtZV9pZCwgZXA7DQo+
ICstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0t
LS0tLS0tLS0tLS0rDQo+IHwgY291bnQoKikgfCB0YXJnZXRfbmFtZV9pZCB8IGVwICAgfCBhdmco
Ym90dG9tKSB8IGF2ZyhhdmVyYWdlcykgICB8DQo+ICstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t
LS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rDQo+IHwgICAgICAgMTgg
fCAgICAgICAgICAgICA0NCB8IDEsMSAgfCAgMjEuODA1NjY2NyB8ICAyMS44NTQ1ODMzMDAwMCB8
DQo+IHwgICAgICAgMTggfCAgICAgICAgICAgICA0NCB8IDEsMiAgfCAxMjEuNzk4NDQ0NCB8IDEy
MS44Mzk4MzMzNTAwMCB8DQo+IHwgICAgICAgMTggfCAgICAgICAgICAgICA0NCB8IDEsMyAgfCAz
NDkuNzYzNDQ0NCB8IDM0OS43NTAxNjY2NTAwMCB8DQo+ICstLS0tLS0tLS0tKy0tLS0tLS0tLS0t
LS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rDQo+IDMgcm93cyBp
biBzZXQgKDAuMDEgc2VjKQ0KPiANCj4gVGhlIGNvdW50IGZvciBlYWNoIHJvdyBzaG91bGQgYmUg
OS4gV2hhdCBkbyBJIG5lZWQgaW4gbXkgY291bnQoKSB0byBiZQ0KPiBjb3VudGluZyB0aGUgcmln
aHQgdGhpbmc/DQo+IA0KPiANCj4gVElBIQ0KPiAtbGFycnkNCj4gDQo+IC0tDQo+IE15U1FMIEdl
bmVyYWwgTWFpbGluZyBMaXN0DQo+IEZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlz
cWwuY29tL215c3FsDQo+IFRvIHVuc3Vic2NyaWJlOiAgICBodHRwOi8vbGlzdHMubXlzcWwuY29t
L215c3FsDQoNCg==