[thelist] mysql - selecting based on count of key
David Siedband
technique at oceanicsky.com
Mon May 9 16:40:43 CDT 2005
I have an index table that linkes to Projects and Documents based on
foreign keys: ProjID , DocID, and I want to find documents that are
linked to more than a threshold number of projects.
trying some vartions on this...
select distinct ProjID
from ProjectDocuments
where Count(DocID) > '3'
Can this be done in a single query?
thanks
--
David
More information about the thelist
mailing list