DrDoc - 4:36 pm on Oct 9, 2013 (gmt 0)
There was no mention of aggregate functions ... Any one in particular you are concerned with? It sounds like you may need to use groupings and/or sub-queries.
I'm sorry if I'm being vague, but I only have vague details to base my answers on.
An example (even greatly simplified and examplified) would be great.