Fabio, Agnes
This returns no records. If I remove the statement "AND X.continent#S.continent" it returns some 1700 records. It does appear to include both expected and unwanted records.
Agnes suggests puting the statement "AND X.continent#S.continent" in where clause. Doing that returns no records.
Ken
>Hi Ken,
>
>try this:
>
>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
>
>
>Fabio