Forum OpenACS Q&A: Re: how to select distinct events from calendar

one question, though: would it make sense (or is it even common practice?) to do the grouping in the .xql statement and THEN (re)-select from that in the .tcl file?

or can i have "nested" queries in the .xql file ala

  <fullquery name="grouped_events">
... select distinct recurrance_id, calendar_id from acs_events
....
</fullquery>

and then

  <fullquery name="single_events">
... select from grouped_events, acs_events
....
</fullquery>