[Zope-DB] ZPT SQL newbie question

[Charlie Clark]

On 2003-09-19 at 01:56:23 [+0200], Ray Kimsey wrote:
> Does anyone know how to achieve this sort of  "group by" effect ?
> 
> Part two is how to set the initiative argument to the ZSQL method (above 
> it is hard coded to 'ssf') to the string value of  here/id.

You need to run two queries to achieve this result or maybe one query in a 
PythonScript with some processing.

Your first query would GROUP BY focus_area, the second query would provide 
the individual results within the group.

Charlie