The solution for two authors: SELECT pp.paper_id FROM papers_people pp, ( SELECT paper_id FROM papers_people WHERE person_id =1740 ) AS pp2 WHERE pp.paper_id = pp2.paper_id AND person_id = 18 Well, that was easy :) On Tue, 22 Dec 2009, Kenny Billiau wrote:
Hi,
let's say I've got a table with 'paper_id' and 'author_id'. Now given x author id's, give me all papers that have those x authors,
It's fairly easy for two authors, but that solution doesn't work for multiple authors :/
Kenny
-- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau@ugent.be http://bioinformatics.psb.ugent.be ================================================================== "When we have each other, we have everything" - Douglas P.