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