Forums

This topic is locked

Grouping my results

Posted 06 May 2002 10:24:54
1
has voted
06 May 2002 10:24:54 retailteam bv posted:
Hi there,

got this problem and i think i can't fix it, hope someone can help.

SELECT forumreactie.idstelling, forumreactie.naam, forumreactie.tijd, forumreactie.datum
FROM forum INNER JOIN forumreactie ON forum.Id = forumreactie.idstelling
WHERE FORUM.Archief = FALSE
ORDER BY forumreactie.idstelling DESC

I would like to see the results of this query grouped by forumreactie.idstelling


the tabels in the db:
FORUM | Id, titel, omschrijving, stelling, naam, mailadrs, datum, ipadrs, archief
FORUMREACTIE | autoid, naam, email, reactie, ipnummer, datum, tijd, idstelling

Reply to this topic