Im making a search page for a site that runs from a database. In the past I would simply use an SQL statement such as<BR><BR>SELECT * FROM Content WHERE ContentBody LIKE '%Keyword%'<BR><BR>And it works fine for me. But the site im currently working on has 2 levels of content, and im not sure how to set it up. I've tryed<BR><BR>SELECT * FROM Content LEFT JOIN SubContent On Content.ContentID = SubContent.ContentID WHERE (ContentBody LIKE '%Keyword%' OR SubContentBody LIKE '%Keyword%')<BR><BR>Which sorta works, but creates more problems then it solves. ie, if the keyword is found in SubContent, the Content is also returned, and if it is in both the Content and SubContent only 1 record is counted. I want it to be able to return the results for Content or SubContent in the same list. Does anybody have any suggestions on what I should do to get this to work the way I want it to?