Hi guys, I've got a query whereby I am getting a list of all authors (table: tbl_020authorDetails) in my database. I am cross referencing against all the articles (tbl_020articleDetails) and only displaying the authors who have an article published (articleAuthenticated = 1). The problem I am coming across is that when an author has two articles published it is displaying their name twice in my list and of course I only want it outputted the once. Can anyone see where I'm going wrong? <!-- Get author information --> <cfquery name="GetAuthors" datasource="user020"> SELECT tbl_020authorDetails.authorID, tbl_020articleDetails.authorID, authorFirstName, authorSurname, articleAuthenticated FROM tbl_020authorDetails, tbl_020articleDetails WHERE tbl_020authorDetails.authorID = tbl_020articleDetails.authorID and tbl_020articleDetails.articleAuthenticated = 1 </cfquery> Thanks very much for your help. Saturday
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
