SELECT DISTINCT p1.people_id,p1.fullname,p1.company_id,c1.company_name,p1.city,p1.state,p1.country,p1.user_id
FROM #people p1 INNER JOIN #company C1 ON c1.company_id=p1.company_id
INNER JOIN #BackupPeople Bp1 ON c1.company_id=Bp1.company_id
WHERE
p1.verify_status='Yes'
AND p1.royalty='Yes'
AND p1.user_id=1
AND p1.delete_status='No'