Hi Askraf, I added the 'distinct' clause to stop any repeated rows, so yes I think that would help.
Much depends how you wish to present the results. If you are happy for a simple list of page titles, then what I proposed seems reasonable. I thought you might be showing a link to each page, and following the link would show the page with its comments underneath. You say that your 'question is not clear enough' and 'which one I prefer'. Well, I'm not sure either :) Just experiment and see whether you can get it working how you would like. We can always help when you get stuck again. All the best, D On Tuesday, November 6, 2012 7:11:16 PM UTC, apps in tables wrote: > > Thank you vilas, > > I think my question is not clear enough for me. > > I mean: > 1- searching page and comment may mean searching the result of joining > the two tables, which will lead to repetition of the found page (# of > repetitions are the number of associated comments). can 'distinct' solve > these repetitions? > > Or > 2- searching page and comment may mean searching each table separately > and then joining (leftly) the two set of results. > > which one do you prefer? > > Regards, > > Ashraf > --
