subject:"union and group by"

Re: union and group by

2004-08-19 Thread SGreen

ave it out of the query. Regards, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jesper Goos <[EMAIL PROTECTED]> wrote on 08/19/2004 05:07:55 AM: > Hi > > I'm having problems with a union and group by... > My query looks like this... > > (selec

union and group by

2004-08-19 Thread Jesper Goos

Hi I'm having problems with a union and group by... My query looks like this... (select count(*) as numberOfC,Customer.country,Customer.creationdate FROM Customer,VIP where Customer.id=VIP.customer and VIP.brand=2 and Customer.creationdate > '1999-31-01' group by country) u