To confirm, MySQL still can't do sub queries right?
ie. select * from people where pplID not in (select distinct pplID from pplStatus)