My query is: SELECT id, title_analytic, date, keyword_article, author_article, keyword, name FROM Article, Years, Keyword_Info, Keywords, Author_Info, Authors WHERE Article.id = Keyword_Info.keyword_article AND Article.id = Author_Info.author_article AND Article.date_of_pub = Years.yearsid AND Keyword_Info.keyword = Keywords.keywords_id AND Author_Info.author = Authors.authors_id AND Authors.name LIKE '%david%' ORDER BY title_analytic, name LIMIT 20;
This query produces a mixed bag. It will return the proper articles, however it will return multiple instances of the same article. Is there a way for my to prevent the query from returning results that are duplicate? Thanks for the help in advance, Shaun --------------------------------------------------------------------- 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
