Sum and Group problem with MSSQL

[zu]

I do a quiet complex query based on users form input. The result looks
something like this (simplified, irrelevant data and fields truncated)

cat_id | producttext
-------------------------------------
1002 | Parma Schinken
1013 | Bordeaux
5006 | Parma Schinken
1005 | Something
1002 | Another Product from Kat 1002

As you can see the first and last record have the same cat_id.

What I want in the end is to know the percentages of products in the same
range (1001-2000, 2001-3000...)
and the percentage of products within the same cat (like 1002)

I do it simply by doing a subquery on each range, see attached code (query1).
The problem is I don't only need the cat_id but it's language dependent name.

I can get it with query like this (see query2) but, it wont function if the
FROM is another query. It only works if I Select from a real table.

Any hints what to do different?

What I actually want in the end is a table like this:

2 1002 Fleisch
1 1005 Beilagen, Pasta, Reis, Konserven
1 1013 Anderes








-- query1 --
SELECT COUNT(*) as Anzahl,cat_id
FROM qgetAuswertung1
WHERE cat_id > 1000 AND cat_id< 2000
GROUP BY cat_id

-- query2 --
SELECT COUNT(*) AS Anzahl,
qgetAuswertung1.users_statdata_productsubcategorie ID,

tCmsElementCustomLieblingsproduktProductSubcategor ie.productsubcategorie_descrip
tion_DE
FROM qgetAuswertung1 INNER JOIN
tCmsElementCustomLieblingsproduktProductSubcategor ie ON
qgetAuswertung1.users_statdata_productsubcategorie ID =
tCmsElementCustomLieblingsproduktProductSubcategor ie.productsubcategorieID
WHERE (qgetAuswertung1.users_statdata_productsubcategori eID > 1000) AND
(qgetAuswertung1.users_statdata_productsubcategori eID <
2000)
GROUP BY qgetAuswertung1.users_statdata_productsubcategorie ID,

tCmsElementCustomLieblingsproduktProductSubcategor ie.productsubcategorie_descrip
tion_DE

[Dan Bracuk]

You can't use the keyword join in Q of Q. You have to do it the old fashioned way.

select somefields
from query1, query2
where query1.field = query2.field

[zu]

This have I done.
I actually didi the Join in the 'base'-query.

Thanks