Oh sorry, in my posted version of the Query i forgot a Group by clause. the Query that i have used is:
select data.name from data, dat2cat where data.pk_data = dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18) group by data.name having count(data.name) > 1; Simon Klaiber -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php