I have a table in DB that has messages exchanged between groups and I need to create a table like this one (messages exchanged between 2 groups):
knowing that Gr1,.... are group names from DB and numbers are from DB too.Edited to add sQL query (given by Sarah in comments -below):\[code\](SELECT COUNT( Msg_ID ) AS msgcount, Group_ID, To_Group_ID FROM messages GROUP BY Group_ID, To_Group_ID)\[/code\]