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 --