This where clause is incorrect, it should be on orderer.person_id because remember orders is a user_id and not person_id since you are doing a select person_id from provider, makes sense?