On Apr 27, 1:37 pm, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:

>
> You have missed out a comma after Qty.

Yep, you're correct and that explains the first error. However, with
the comma in place, I get this:

#1111 - Invalid use of group function

I suppose I'll have to do a second select statement to get the size
information and concatenate the two results sets. It's not elegant
but is there any other way?

Thanks,
BB