Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Level extraction
Message
 
To
31/10/2000 14:53:24
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Level extraction
Miscellaneous
Thread ID:
00436488
Message ID:
00436490
Views:
15
Christian,

Try isnull() instead of value=null

SELECT Item.Item
FROM Item LEFT JOIN BOM ON Item.Item = BOM.ItemParent
WHERE isnull(BOM.ItemParent);
GROUP BY Item.Item;
Dan Goodwin
Primary Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform