Help with SELECT clause

--0016e6d977c09e94a00478efabd6
Content-Type: text/plain; charset=ISO-8859-1

I'm stuck again ... and perhaps it's just not designed right, but I
inherited this setup, so if anyone has suggestions on how to make it better,
I'm all ears. This is all one table ...

describe approvals;
+-----------+--------------------------+------+-----+------- --+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-----------+--------------------------+------+-----+------- --+----------------+
| id | int(6) | NO | PRI | NULL |
auto_increment |
| photo_uid | int(7) unsigned zerofill | NO | | NULL
| |
| adminname | varchar(100) | NO | | NULL
| |
| status | int(1) | NO | | NULL
| |
+-----------+--------------------------+------+-----+------- --+----------------+


SELECT * FROM approvals;
+----+-----------+-----------+--------+
| id | photo_uid | adminname | status |
+----+-----------+-----------+--------+
| 6 | 0000028 | admin1 | 1 |
| 13 | 0000016 | admin1 | 0 |
| 49 | 0000016 | admin2 | 1 |
| 16 | 0000018 | admin1 | 1 |
| 50 | 0000018 | admin2 | 0 |
+----+-----------+-----------+--------+


The goal, here is to capture everything that does not have 'admin2' in the
adminname column, however duplicated records in the photo_uid column should
also be excluded.

SELECT * FROM approvals WHERE adminname != 'admin2';
+----+-----------+-----------+--------+
| id | photo_uid | adminname | status |
+----+-----------+-----------+--------+
| 6 | 0000028 | admin1 | 1 |
| 13 | 0000016 | admin1 | 0 |
| 16 | 0000018 | admin1 | 1 |
+----+-----------+-----------+--------+


However, I also need to exclude photo_uid '0000016' and '0000018' because
both of them are already tagged by 'admin2'. The only record that needs to
be returned here is '0000028' ...

I just don't know how to do that, or if it's even possible to do in a single
query. I can get it done in two, but I'm hoping for a single query here ...

--0016e6d977c09e94a00478efabd6--

Re:Help with SELECT clause

------=_Part_92699_14866661.1258885674636
Content-Type: text/plain; charset=gbk
Content-Transfer-Encoding: base64

SGlcSSB0aGluayB5b3UgY2FuIGFjaGlldmUgdGhpcyB1c2luZyBhIHNpbmds ZSBxdWVyeSBsaWtl
IHRoaXM6IFNFTEVDVCAqIEZST00gYXBwcm92YWxzIFdIRVJFIGFkbWlubmFt ZSAhPSAnYWRtaW4y
J2FuZCBwaG90b191aWQgaW4gKHNlbGVjdCBwaG90b191aWQgZnJvbSBhcHBy b3ZhbHMgd2hlcmUg
YWRtaW5uYW1lPSdhZG1pbjInKSwgb2YgY291cnNlLCBtYXliZSBpdCdzIG5v dCB0aGUgYmVzdCBz
b2x1dGlvbiwganVzdCBmb3IgeW91ciBpbmZvcm1hdGlvbi7U2jIwMDktMTEt MjKjrCJBc2hsZXkg
TS4gS2lyY2huZXIiIDxraXJhc2g0QGdtYWlsLmNvbT4g0LS1wKO6Cj5JJ20g c3R1Y2sgYWdhaW4g
Li4uIGFuZCBwZXJoYXBzIGl0J3MganVzdCBub3QgZGVzaWduZWQgcmlnaHQs IGJ1dCBJCj5pbmhl
cml0ZWQgdGhpcyBzZXR1cCwgc28gaWYgYW55b25lIGhhcyBzdWdnZXN0aW9u cyBvbiBob3cgdG8g
bWFrZSBpdCBiZXR0ZXIsCj5JJ20gYWxsIGVhcnMuICBUaGlzIGlzIGFsbCBv bmUgdGFibGUgLi4u
Cj4KPmRlc2NyaWJlIGFwcHJvdmFsczsKPistLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLSstLS0tLS0rLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0rCj58IEZpZWxk
ICAgICB8IFR5cGUgICAgICAgICAgICAgICAgICAgICB8IE51bGwgfCBLZXkg fCBEZWZhdWx0IHwK
PkV4dHJhICAgICAgICAgIHwKPistLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LSstLS0tLS0rLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rCj58 IGlkICAgICAgICB8
IGludCg2KSAgICAgICAgICAgICAgICAgICB8IE5PICAgfCBQUkkgfCBOVUxM ICAgIHwKPmF1dG9f
aW5jcmVtZW50IHwKPnwgcGhvdG9fdWlkIHwgaW50KDcpIHVuc2lnbmVkIHpl cm9maWxsIHwgTk8g
ICB8ICAgICB8IE5VTEwKPnwgICAgICAgICAgICAgICAgfAo+fCBhZG1pbm5h bWUgfCB2YXJjaGFy
KDEwMCkgICAgICAgICAgICAgfCBOTyAgIHwgICAgIHwgTlVMTAo+fCAgICAg ICAgICAgICAgICB8
Cj58IHN0YXR1cyAgICB8IGludCgxKSAgICAgICAgICAgICAgICAgICB8IE5P ICAgfCAgICAgfCBO
VUxMCj58ICAgICAgICAgICAgICAgIHwKPistLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLSstLS0tLS0rLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0rCj4KPgo+U0VM
RUNUICogRlJPTSBhcHByb3ZhbHM7Cj4rLS0tLSstLS0tLS0tLS0tLSstLS0t LS0tLS0tLSstLS0t
LS0tLSsKPnwgaWQgfCBwaG90b191aWQgfCBhZG1pbm5hbWUgfCBzdGF0dXMg fAo+Ky0tLS0rLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0rCj58ICA2IHwgICAwMDAw MDI4IHwgYWRtaW4x
ICAgIHwgICAgICAxIHwKPnwgMTMgfCAgIDAwMDAwMTYgfCBhZG1pbjEgICAg fCAgICAgIDAgfAo+
fCA0OSB8ICAgMDAwMDAxNiB8IGFkbWluMiAgICB8ICAgICAgMSB8Cj58IDE2 IHwgICAwMDAwMDE4
IHwgYWRtaW4xICAgIHwgICAgICAxIHwKPnwgNTAgfCAgIDAwMDAwMTggfCBh ZG1pbjIgICAgfCAg
ICAgIDAgfAo+Ky0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0t LS0rCj4KPgo+VGhl
IGdvYWwsIGhlcmUgaXMgdG8gY2FwdHVyZSBldmVyeXRoaW5nIHRoYXQgZG9l cyBub3QgaGF2ZSAn
YWRtaW4yJyBpbiB0aGUKPmFkbWlubmFtZSBjb2x1bW4sIGhvd2V2ZXIgZHVw bGljYXRlZCByZWNv
cmRzIGluIHRoZSBwaG90b191aWQgY29sdW1uIHNob3VsZAo+YWxzbyBiZSBl eGNsdWRlZC4KPgo+
U0VMRUNUICogRlJPTSBhcHByb3ZhbHMgV0hFUkUgYWRtaW5uYW1lICE9ICdh ZG1pbjInOwo+Ky0t
LS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0rCj58IGlkIHwg cGhvdG9fdWlkIHwg
YWRtaW5uYW1lIHwgc3RhdHVzIHwKPistLS0tKy0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tKy0tLS0t
LS0tKwo+fCAgNiB8ICAgMDAwMDAyOCB8IGFkbWluMSAgICB8ICAgICAgMSB8 Cj58IDEzIHwgICAw
MDAwMDE2IHwgYWRtaW4xICAgIHwgICAgICAwIHwKPnwgMTYgfCAgIDAwMDAw MTggfCBhZG1pbjEg
ICAgfCAgICAgIDEgfAo+Ky0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0r LS0tLS0tLS0rCj4K
Pgo+SG93ZXZlciwgSSBhbHNvIG5lZWQgdG8gZXhjbHVkZSBwaG90b191aWQg JzAwMDAwMTYnIGFu
ZCAnMDAwMDAxOCcgYmVjYXVzZQo+Ym90aCBvZiB0aGVtIGFyZSBhbHJlYWR5 IHRhZ2dlZCBieSAn
YWRtaW4yJy4gIFRoZSBvbmx5IHJlY29yZCB0aGF0IG5lZWRzIHRvCj5iZSBy ZXR1cm5lZCBoZXJl
IGlzICcwMDAwMDI4JyAuLi4KPgo+SSBqdXN0IGRvbid0IGtub3cgaG93IHRv IGRvIHRoYXQsIG9y
IGlmIGl0J3MgZXZlbiBwb3NzaWJsZSB0byBkbyBpbiBhIHNpbmdsZQo+cXVl cnkuICBJIGNhbiBn
ZXQgaXQgZG9uZSBpbiB0d28sIGJ1dCBJJ20gaG9waW5nIGZvciBhIHNpbmds ZSBxdWVyeSBoZXJl
IC4uLgo=
------=_Part_92699_14866661.1258885674636--

Re:Re:Help with SELECT clause

------=_Part_93420_10246732.1258886676346
Content-Type: text/plain; charset=gbk
Content-Transfer-Encoding: base64

SSdtIHNvcnJ5IGZvciBtaXNzaW5nIHRoZSBrZXkgd29yZCAibm90IiwgaXQg c2hvdWxkIGJlIFNF
TEVDVCAqIEZST00gYXBwcm92YWxzIFdIRVJFIGFkbWlubmFtZSAhPSAnYWRt aW4yJ2FuZCBwaG90
b191aWQgbm90IGluIChzZWxlY3QgcGhvdG9fdWlkIGZyb20gYXBwcm92YWxz IHdoZXJlIGFkbWlu
bmFtZT0nYWRtaW4yJyksCgoKCgrU2jIwMDktMTEtMjKjrHNoanVuc2luIDxz aGp1bnNpbkAxNjMu
Y29tPiDQtLXAo7oKPkhpXEkgdGhpbmsgeW91IGNhbiBhY2hpZXZlIHRoaXMg dXNpbmcgYSBzaW5n
bGUgcXVlcnkgbGlrZSB0aGlzOiBTRUxFQ1QgKiBGUk9NIGFwcHJvdmFscyBX SEVSRSBhZG1pbm5h
bWUgIT0gJ2FkbWluMidhbmQgcGhvdG9fdWlkIGluIChzZWxlY3QgcGhvdG9f dWlkIGZyb20gYXBw
cm92YWxzIHdoZXJlIGFkbWlubmFtZT0nYWRtaW4yJyksIG9mIGNvdXJzZSwg bWF5YmUgaXQncyBu
b3QgdGhlIGJlc3Qgc29sdXRpb24sIGp1c3QgZm9yIHlvdXIgaW5mb3JtYXRp b24u1NoyMDA5LTEx
LTIyo6wiQXNobGV5IE0uIEtpcmNobmVyIiA8a2lyYXNoNEBnbWFpbC5jb20+ INC0tcCjugo+Pkkn
bSBzdHVjayBhZ2FpbiAuLi4gYW5kIHBlcmhhcHMgaXQncyBqdXN0IG5vdCBk ZXNpZ25lZCByaWdo
dCwgYnV0IEkKPj5pbmhlcml0ZWQgdGhpcyBzZXR1cCwgc28gaWYgYW55b25l IGhhcyBzdWdnZXN0
aW9ucyBvbiBob3cgdG8gbWFrZSBpdCBiZXR0ZXIsCj4+SSdtIGFsbCBlYXJz LiAgVGhpcyBpcyBh
bGwgb25lIHRhYmxlIC4uLgo+Pgo+PmRlc2NyaWJlIGFwcHJvdmFsczsKPj4r LS0tLS0tLS0tLS0r
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tKy0tLS0t LS0tLSstLS0tLS0t
LS0tLS0tLS0tKwo+PnwgRmllbGQgICAgIHwgVHlwZSAgICAgICAgICAgICAg ICAgICAgIHwgTnVs
bCB8IEtleSB8IERlZmF1bHQgfAo+PkV4dHJhICAgICAgICAgIHwKPj4rLS0t LS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tKy0tLS0tLS0t LSstLS0tLS0tLS0t
LS0tLS0tKwo+PnwgaWQgICAgICAgIHwgaW50KDYpICAgICAgICAgICAgICAg ICAgIHwgTk8gICB8
IFBSSSB8IE5VTEwgICAgfAo+PmF1dG9faW5jcmVtZW50IHwKPj58IHBob3Rv X3VpZCB8IGludCg3
KSB1bnNpZ25lZCB6ZXJvZmlsbCB8IE5PICAgfCAgICAgfCBOVUxMCj4+fCAg ICAgICAgICAgICAg
ICB8Cj4+fCBhZG1pbm5hbWUgfCB2YXJjaGFyKDEwMCkgICAgICAgICAgICAg fCBOTyAgIHwgICAg
IHwgTlVMTAo+PnwgICAgICAgICAgICAgICAgfAo+Pnwgc3RhdHVzICAgIHwg aW50KDEpICAgICAg
ICAgICAgICAgICAgIHwgTk8gICB8ICAgICB8IE5VTEwKPj58ICAgICAgICAg ICAgICAgIHwKPj4r
LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t Ky0tLS0tKy0tLS0t
LS0tLSstLS0tLS0tLS0tLS0tLS0tKwo+Pgo+Pgo+PlNFTEVDVCAqIEZST00g YXBwcm92YWxzOwo+
PistLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tKwo+Pnwg aWQgfCBwaG90b191
aWQgfCBhZG1pbm5hbWUgfCBzdGF0dXMgfAo+PistLS0tKy0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0t
Ky0tLS0tLS0tKwo+PnwgIDYgfCAgIDAwMDAwMjggfCBhZG1pbjEgICAgfCAg ICAgIDEgfAo+Pnwg
MTMgfCAgIDAwMDAwMTYgfCBhZG1pbjEgICAgfCAgICAgIDAgfAo+PnwgNDkg fCAgIDAwMDAwMTYg
fCBhZG1pbjIgICAgfCAgICAgIDEgfAo+PnwgMTYgfCAgIDAwMDAwMTggfCBh ZG1pbjEgICAgfCAg
ICAgIDEgfAo+PnwgNTAgfCAgIDAwMDAwMTggfCBhZG1pbjIgICAgfCAgICAg IDAgfAo+PistLS0t
Ky0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tKwo+Pgo+Pgo+PlRo ZSBnb2FsLCBoZXJl
IGlzIHRvIGNhcHR1cmUgZXZlcnl0aGluZyB0aGF0IGRvZXMgbm90IGhhdmUg J2FkbWluMicgaW4g
dGhlCj4+YWRtaW5uYW1lIGNvbHVtbiwgaG93ZXZlciBkdXBsaWNhdGVkIHJl Y29yZHMgaW4gdGhl
IHBob3RvX3VpZCBjb2x1bW4gc2hvdWxkCj4+YWxzbyBiZSBleGNsdWRlZC4K Pj4KPj5TRUxFQ1Qg
KiBGUk9NIGFwcHJvdmFscyBXSEVSRSBhZG1pbm5hbWUgIT0gJ2FkbWluMic7 Cj4+Ky0tLS0rLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0rCj4+fCBpZCB8IHBob3Rv X3VpZCB8IGFkbWlu
bmFtZSB8IHN0YXR1cyB8Cj4+Ky0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0rLS0tLS0tLS0r
Cj4+fCAgNiB8ICAgMDAwMDAyOCB8IGFkbWluMSAgICB8ICAgICAgMSB8Cj4+ fCAxMyB8ICAgMDAw
MDAxNiB8IGFkbWluMSAgICB8ICAgICAgMCB8Cj4+fCAxNiB8ICAgMDAwMDAx OCB8IGFkbWluMSAg
ICB8ICAgICAgMSB8Cj4+Ky0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0r LS0tLS0tLS0rCj4+
Cj4+Cj4+SG93ZXZlciwgSSBhbHNvIG5lZWQgdG8gZXhjbHVkZSBwaG90b191 aWQgJzAwMDAwMTYn
IGFuZCAnMDAwMDAxOCcgYmVjYXVzZQo+PmJvdGggb2YgdGhlbSBhcmUgYWxy ZWFkeSB0YWdnZWQg
YnkgJ2FkbWluMicuICBUaGUgb25seSByZWNvcmQgdGhhdCBuZWVkcyB0bwo+ PmJlIHJldHVybmVk
IGhlcmUgaXMgJzAwMDAwMjgnIC4uLgo+Pgo+PkkganVzdCBkb24ndCBrbm93 IGhvdyB0byBkbyB0
aGF0LCBvciBpZiBpdCdzIGV2ZW4gcG9zc2libGUgdG8gZG8gaW4gYSBzaW5n bGUKPj5xdWVyeS4g
IEkgY2FuIGdldCBpdCBkb25lIGluIHR3bywgYnV0IEknbSBob3BpbmcgZm9y IGEgc2luZ2xlIHF1
ZXJ5IGhlcmUgLi4uCg==
------=_Part_93420_10246732.1258886676346--