Is there a means to take the statement below and extract the data from the driving table to either create a temporary table/view and/or drive a report directly?
The goal is to have the report provide the detail for only those instances where the SCANID exceeds the count number. An ordinary WHERE clause will display each instance of a unique SCANID in addition to multiple instances of the same SCANID when the report is defined correctly, which I currently have. But the report is long due to single occurrences of SCANID and I am only interested in multiple occurrences of SCANID. Seems like a temporary table/view would be ideal to drive the report. SELECT scanid COUNT(*) FROM scan1 GROUP BY scanid HAVING COUNT(*) > 20 Thank You Steve Johnson -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.com.
