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