SQL subsets
Try this using your table and field names --
SELECT Permitee
FROM YourTable
GROUP BY YourTable.Permitee
HAVING (((Count(YourTable.[Items]))=3));
--
Build a little, test a little.
"Stacy in Savannah" wrote:
I have a set of Permitees 12,000+, who own one or more items 58,908 of a list
of 29 items. Some Permitees are only allow to own 3 of these 29 items,
others can own 1-29. I need a SQL that will return DISTINCT permitees that
own 1-3 of those ONLY allowable items. Would anyone help guide me toward a
proper solution?
THANK YOU
|