Gunnar I always do it at the command line too. But a quick test shows that if you add GROUP BY <columns> to the end of the where clause in the query builder, it works. Dawn
-----Original Message----- From: Gunnar Ekblad [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 12:25 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Query I won't answer my own question, but I did it for my DB from command line and it did work as expected. My preference is actually to do it from command line, but first time I try do a new thing (a new thing for me, not for R:base) I try to do it thru menus. But I still can't find Group By in query builder. If its only me I will drop the subject. Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gunnar Ekblad Sent: den 25 april 2005 17:16 To: RBG7-L Mailing List Subject: [RBG7-L] - Query Query Builder. I am trying in my own db to create a query very close to YT3 in RRBYW10 Quote from query defintion FROM InvoiceHeader T35,Customer T9 WHERE T35.CustID = T9.CustID ORDER BY Company ASC GROUP BY T35.CustID,T9.Company But I am missing where I can put the group by clause in the query builder Or do I have to create the query from Command line (or a commandfile)? Gunnar Ekblad
