SELECT genus, species, continent ; FROM species JOIN site ON species.pkey = site.fkey ; WHERE site.continent = 'Asia' ; AND genus + species IN ( ; SELECT genus + species ; FROM species JOIN site ON species.pkey = site.fkey ; WHERE site.continent = 'Africa' ); UNION ; SELECT genus, species, continent ; FROM species JOIN site ON species.pkey = site.fkey ; WHERE site.continent = 'Africa' ; AND genus + species IN ( ; SELECT genus + species ; FROM species JOIN site ON species.pkey = site.fkey ; WHERE site.continent = 'Asia' ); ORDER BY 1,2 ; INTO CURSOR curAA