SELECT au1.au_fname, au1.au_lname, au2.au_fname, au2.au_lname
FROM authors au1, authors au2
WHERE au1.city="Oakland" AND au2.city="Oakland" AND au1.state="CA" AND au2.state="CA" AND au1.zip=au2.zip;