Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql and where clauses
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Sql and where clauses
Miscellaneous
Thread ID:
00236881
Message ID:
00237054
Views:
12
Mark,

The problem is the NULLs in the result set. You are not filtering them out with the where.

... WHERE yy.Whatever ...
HAVING NOT ISNULL(Whatever)
Janis

www.JamesBooth.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform