Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Puzzle
Message
From
28/11/2003 02:39:40
Walter Meester
HoogkarspelNetherlands
 
 
To
27/11/2003 21:47:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00854130
Message ID:
00854143
Views:
20
Hi Ken,

How about,
SELECT genus, species, continent ; 
    FROM Species P INNER JOIN Site S ON P.Pkey = S.fkey ;
    WHERE S.continent IN ('Africa','Asia') AND ;
        EXISTS (SELECT * FROM Site WHERE fKey = P.Key AND Continent = 'Asia') AND ;
        EXISTS (SELECT * FROM Site WHERE fKey = P.Key AND Continent = 'Africa') ;
    ORDER BY 1,2
Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform