Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excluding NULL values in an SQL query
Message
From
04/04/2002 07:54:38
Denis Filer
University of Oxford
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Excluding NULL values in an SQL query
Miscellaneous
Thread ID:
00640805
Message ID:
00640805
Views:
54
I am using an SQL command (with a left outer join) that bring data from two table together. In some cases, where records are missing, the records are added with NULL values. Set NULL off doesn’t apply in select sql commands (so I think). Is there a way to suppress those nulls? Thank you.
Next
Reply
Map
View

Click here to load this message in the networking platform