Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering without Group By and Having ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00590837
Message ID:
00590865
Views:
23
Steve,

Try something like this;
SELECT * ;
  FROM MyTable ;
 WHERE First condition is true ;
   AND MyTable.Primarykey NOT IN (SELECT PrimaryKey ;
                                    FROM MyTable BB ;
                                   WHERE Second condition is not .T.) ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform