I have a Products table that has ProductID(PK) and Description fields.
Another table Orders has OrderID(PK),ProductID(Foriegn Key) and some other fields.

I want to create a join between the two tables that gives me ProductID, Description and the NumInst (a count of ProductID in
Orders).

It should be pretty simple SQL but I have been having a tough time over it. I get a
" you tried to execute a query that does not
include the specified expression 'ProductID' as part of an aggregate function " error.