Re:Help with SELECT clause

Hi\I think you can achieve this using a single query like this: SELECT * FROM approvals WHERE adminname != 'admin2'and photo_uid in (select photo_uid from approvals where adminname='admin2'), of course, maybe it's not the best solution, just for your information.在2009-11-22，Ashley M. Kirchner

Re:Re:Help with SELECT clause

I'm sorry for missing the key word not, it should be SELECT * FROM approvals WHERE adminname != 'admin2'and photo_uid not in (select photo_uid from approvals where adminname='admin2'), 在2009-11-22，shjunsin shjun...@163.com 写道： Hi\I think you can achieve this using a single query like