I have three tables, Product, FactSheet and FactSheetItem.<BR><BR>A Product can have one fact sheet, that in turn has many Items, however a Product does not have to have a Fact Sheet<BR><BR>I need to perform a search on the Product name, and the related FactSheetItem descriptions.<BR><BR>Problems encountered are :<BR><BR>1. It is returning the same product more than once<BR>2. It is only searching for Products that have FactSheets<BR><BR>I need to be able to do this in SQL, as there can potentially be alot of records