combining select statements

[Anon]

Hi,

I\'ve have 2 select statements which bring back two sets of results. I was wondering if it is possible to combine these into one select statement.

Here are the statements:

SELECT ProductCategory, COUNT(ProductCategory) as catCount FROM product Where ProductSection = \'structure\' GROUP BY ProductCategory

This gets the product categories and the number of categories.

SELECT ProductSection,ProductCategory,COUNT(ProductCategory) as catCount FROM product WHERE ProductSection = \'structure\' and TO_DAYS(NOW()) - TO_DAYS(uploadDate) <= 7 GROUP BY ProductCategory;

This gets the product categories and the number of categories uploaded in the last 7 days.

Many Thanks

Liz

[Anon]

Since you are using the count function I don't think that there is any way you can join these two queries and get the correct data. Your where clause will affect all data returned so you couldn't do both.