1
SELECT p.name, p.phoneNumber, p.emailAddress, a.address1, a.address2, a.city from PERSON p, ADDRESS a WHERE a.p_id = p.id AND p.name like 'john%'