1 reply to this topic

[irfan_s]

That is the query, and I get the error that pcnr has more meanings. My tables look like this:



The query is:

Get the name of the category that has the most products in it.

What is wrong with my query?

TY

[irfan_s]

OK ty anyway. Here is the solution:

select result.PCName, max(result.product_sum) from (select ProductCategory.PCName as PCName,
count(*) as product_sum from Product, ProductCategory where ProductCategory.PCNr = Product.PCNr
group by Product.PCNr) as Result;