Self Join

Which authors in Oakland have the same zip code?

Select distinct au1.au_fname , au1.au_lname, au1.zip

from authors au1, authors au2

where au1.city = “Oakland”

and au1.zip = au2.zip

and au1.au_id != au2.au_id

Previous slide

Next slide

Back to first slide

View graphic version