Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL join with empty data in one table
Message
 
To
14/07/2000 16:17:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00392660
Message ID:
00392721
Views:
11
Christian,

Try this;
SELECT * ;
  FROM Companies Co JOIN Sales Sa ;
    ON Co.keyvalue = Sa.keybedra ;
 WHERE Sa.Price > 0 ;
UNION ALL ;
 SELECT * FROM Companies Comp ;
  WHERE Comp.KeyValue NOT IN (SELECT Keybedra FROM Sales) ;
 INTO CURSOR GoodResult
Previous
Reply
Map
View

Click here to load this message in the networking platform