Forum Stats

  • 3,851,709 Users
  • 2,264,014 Discussions


Complex Queries with Discoverer 3.1

3004 Member Posts: 204,171 Green Ribbon
I have ran a query with some filtered data. With the results of my original query, I need to exclude any duplicates from a matching field in a new worksheet with new conditions in a new query. Can this be done? I have tried using the subquery, but I am not looking for a calculation result or value, like your video store sample. Basically, any Customer ID in the original query that is = to my new set of ID's in my new query need to be excluded in the resulting set.


This discussion has been closed.