[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