Just a quick one really...
If i have the statement:
Code:
SELECT DISTINCT t1.column1, t2.column2
FROM myTable1 t1, myTable2 t2
--etc
Are t1.column1 and t2.column2 both made to be distinct or would there be repetitions in column2? If not, how would i go about making t1.column1 distinct but still have repetitions in t2.column2?
Background: I'm trying to select the last five posts from a forum database but i dont want to show more than one post from the same subforum but if all of the last 5 posts were by the same person on different subforums i still want to show them.
I'll thank you later
