SELECT genus, species, continent ; FROM Site S; INNER JOIN Species ON S.fkey =Species.Pkey AND S.continent IN ('Africa','Asia'); INNER JOIN Site X ON X.fkey =Species.Pkey AND X.continent IN ('Africa','Asia') AND X.continent#S.continent ; ORDER BY 1,2Agnes
SELECT genus, species, continent ; FROM Site S; INNER JOIN Species ON S.fkey =Species.Pkey AND S.continent IN ('Africa','Asia'); INNER JOIN Site X ON X.fkey =Species.Pkey AND X.continent IN ('Africa','Asia') where X.continent#S.continent ; ORDER BY 1,2>Hi Ken,
>SELECT genus, species, continent ; > FROM Species ; > INNER JOIN Site S ON S.fkey =Species.Pkey AND S.continent IN ('Africa','Asia'); > INNER JOIN Site X ON X.fkey =Species.Pkey AND X.continent IN ('Africa','Asia') AND X.continent#S.continent ; >ORDER BY 1,2 >>