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 写道： >Hi\I think you can achieve this using a

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"