Use of same aliases in single query
Rob Golsteijn <[email protected]> Mon, 23 Mar 2020 09:28:58 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
SGkgbGlzdCwKCkFjY2lkZW50YWxseSBJIGRpc2NvdmVyZWQgdGhhdCBJIGNvdWxkIHVzZSB0aGUg c2FtZSB0YWJsZSBhbGlhc2VzIGZvciAyIHRhYmxlcyBpbiBhIHNpbmdsZSBzcWwgc3RhdGVtZW50 LgpBcyBsb25nIGFzIEkgZG8gbm90IHVzZSBhIGNvbHVtbiBuYW1lIHRoYXQgZXhpc3RzIGluIGJv dGggdGFibGVzIFNxbGl0ZSBhY2NlcHRzIHRoaXMuCkl0IGxvb2tzIHN0cmFuZ2UgdG8gbWUgdGhh dCBJIGNhbiB1c2UgdGhlIHNhbWUgYWxpYXNlcyBtdWx0aXBsZSB0aW1lcywgYW5kIHRoYXQgdGhl eSBjby1leGlzdC4KQXMgYSBwcm9ncmFtbWVyIEknbSBub3QgdXNlZCB0byB0aGlzLCBidXQgdGhl IFNxbGl0ZSBkb2NzIGRvIG5vdCBzZWVtIHRvIGZvcmJpZCB0aGlzLiBJcyB0aGlzIGEgYnVnIG9y IGEgZmVhdHVyZT8gCkkgZ3Vlc3MgYmVjYXVzZSBvZiBiYWNrd2FyZCBjb21wYXRpYmlsaXR5IHRo aXMgYmVoYXZpb3Igd2lsbCBub3QgYmUgY2hhbmdlZC4gU29tZXRoaW5nIHRvIGRvY3VtZW50IGlu IGh0dHBzOi8vd3d3LnNxbGl0ZS5vcmcvcXVpcmtzLmh0bWwgPwoKU2ltaWxhciBiZWhhdmlvciBm b3IgcmVzdWx0IHJvdyBhbGlhc2VzLCBidXQgaW4gdGhhdCBjYXNlIHRoZSBhbWJpZ3VvdXMgYWxp YXNlcyBjYW4gZXZlbiBiZSB1c2VkLgoKRXhhbXBsZXMgZHVwbGljYXRlIHRhYmxlIGFsaWFzZXM6 CgoKCkNSRUFURSBUQUJMRSBhYWEgKGEgSU5ULCB6IElOVCk7CkNSRUFURSBUQUJMRSBiYmIgKGIg SU5ULCB6IElOVCk7CgpTRUxFQ1QgMSBGUk9NIGFhYSB4LCBiYmIgeCBPTiB4LmEgPSB4LmI7wqAg LS0gU2FtZSBhbGlhcyAieCIgZm9yIDIgdGFibGVzLCBidXQgbm8gY29tcGxhaW50cyAoYWxsIGNv bHVtbiBuYW1lcyBpbiB0aGUgcXVlcnkgY2FuIGJlIHJlc29sdmVkKQpTRUxFQ1QgMSBGUk9NIGFh YSB4LCBiYmIgeCBPTiB4LnogPSB4Lno7wqAgLS0gIkVycm9yOiBhbWJpZ3VvdXMgY29sdW1uIG5h bWU6IHgueiIKU0VMRUNUICogRlJPTSBhYWEgeCwgYmJiIHggT04geC5hID0geC5iO8KgIC0tICJF cnJvcjogYW1iaWd1b3VzIGNvbHVtbiBuYW1lOiB4LnoiIChkdXJpbmcgZXhwYW5zaW9uIG9mICop CgoKRXhhbXBsZSBkdXBsaWNhdGUgcmVzdWx0IHJvd3MgYWxpYXNlczoKCgoKU0VMRUNUCgrCoMKg wqAgeC5hIGFzIHksCsKgwqDCoCB4LnogYXMgecKgwqDCoCAtLSBTYW1lIGFsaWFzLCBidXQgbm8g Y29tcGxhaW50cwrCoCBGUk9NIGFhYSB4OwoKQW5kIHRoZSByZXN1bHQgcm93IGFsaWFzZXMgY2Fu IGV2ZW4gYmUgdXNlZCBpbiB0aGUgcXVlcnkuCgpJTlNFUlQgSU5UTyAiYWFhIiBWQUxVRVMoMSwy KTsKSU5TRVJUIElOVE8gImFhYSIgVkFMVUVTKDEsMyk7CgpTRUxFQ1QgY291bnQoKSwKwqDCoMKg wqDCoMKgIHguYSBhcyB5LArCoMKgwqDCoMKgwqAgeC56IGFzIHkKwqAgRlJPTSBhYWEgeApHUk9V UCBCWSB5O8KgwqDCoMKgwqDCoCAtLSBObyBjb21wbGFpbnRzLCBldmVuIHRob3VnaCAieSIgaXMg YW1iaWd1b3VzIGhlcmUKCmNvdW50KCl8eXx5CjJ8MXwzwqDCoMKgwqDCoMKgwqDCoCAtLSBMb29r cyBsaWtlIHRoZSBmaXJzdCBhbGlhcyAieSIgaXMgdXNlZC4KClRlc3RlZCB3aXRoIHZlcnNpb25z IDMuMjcuMiBhbmQgMy4xNS4yLgoKUmVnYXJkcywKUm9iIEdvbHN0ZWlqbgoKTWV0IFZyaWVuZGVs aWprZSBHcm9ldCwgS2luZCBSZWdhcmRzLCDosKjoh7Tpl67lgJksCgoKUm9iCgoKLS0tCgoKUm9i IEdvbHN0ZWlqbiDCoMKgwqAgU29mdHdhcmUgRW5naW5lZXIgwqAgwqAgTWFwc2NhcGUKCkx1Y2h0 aGF2ZW53ZWcgMzTCoMKgfMKgwqA1NjU3IEVCIMKgRWluZGhvdmVuwqDCoHzCoMKgVGhlIE5ldGhl cmxhbmRzIApQaG9uZSDCoCszMSAoMCk0MCA3MTEzNTgzwqDCoHzCoCBGYXg6ICszMSAoMCk0MCA3 MTEgMzU5OcKgIAoKd3d3Lm1hcHNjYXBlLmV1IDxodHRwOi8vd3d3Lm1hcHNjYXBlLmV1Lz4gCgoK wqAKCk1hcHNjYXBlIEIuVi4gaXMgSVNPOTAwMToyMDA4IGNlcnRpZmllZC5UaGlzIGUtbWFpbCBh bmQgYW55IGF0dGFjaG1lbnQgbWF5IGNvbnRhaW4gY29ycG9yYXRlIHByb3ByaWV0YXJ5IGluZm9y bWF0aW9uIGFuZCBtYXkgb25seSBiZSByZWFkLCBjb3BpZWQgYW5kIHVzZWQgYnkgdGhlIGludGVu ZGVkIHJlY2lwaWVudC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgaXQgYnkgbWlzdGFrZSwgcGxlYXNl IG5vdGlmeSB1cyBpbW1lZGlhdGVseSBieSByZXBseSBlLW1haWwgYW5kIGRlbGV0ZSB0aGlzIGUt bWFpbCBhbmQgaXRzIGF0dGFjaG1lbnRzIGZyb20geW91ciBzeXN0ZW0uIFdlIGJlbGlldmUgYnV0 IGRvIG5vdCB3YXJyYW50IHRoYXQgdGhpcyBtZXNzYWdlIGFuZCBhbnkgYXR0YWNobWVudHMgYXJl IHZpcnVzIGZyZWUuIE1hcHNjYXBlIEIuVi4gaXMgcmVnaXN0ZXJlZCBhdCB0aGUgS2FtZXIgdmFu IEtvb3BoYW5kZWwgT29zdC1CcmFiYW50IGxvY2F0ZWQgaW4gRWluZGhvdmVuLCBUaGUgTmV0aGVy bGFuZHMgbnVtYmVyIDE3MjEwMjEwCgoKwqAKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUtdXNlcnNA bWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2Nn aS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK