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:
00590927
Views:
28
Glad you got it.

But as I read I kept asking myself why the simple:
...WHERE cStatusDesc == "Ready for Processing"...
wouldn't work for you. What did I miss?

UPDATE: Oops - that would have to be ALLTRIM(cStatusDesc) and you lose Rushmore.

Jim

>Almost. The problem is that it shows records that have both "Ready for processing" and "Processing completed" values. I can only show those rows that do not have "Processing completed" values, ie I need to filter out the rows that have actually completed.
>
>
>>Steve,
>>
>>Is this what you're looking for?
Previous
Reply
Map
View

Click here to load this message in the networking platform