Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECTing records which are NOT DISTINCT
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00095346
Message ID:
00095436
Views:
20
Paul,
Take a look at the IN clause. You may be able to formulate your query by doing
something like this

Select * from table where pkey not in ;
(select col1, col2, col3 from table group by 2,3)

This should return all records not selected in the 2nd query.

Let me know if that works for you..


Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform