I have a master part list table and a in stock table with an entry for each
part. I want a result set from the master table with a count for the parts
in the stock table.
I tried this query:
select m.Part_no, m.Man, m.Model_Application, m.Years, m.Disp,
m.description, m.catalog_comments, m.style, m.sugg_ret, (count(b.part_no))
from makemodel m, bin_list b
where m.part_no = b.part_no
group by m.part_no, b.part_no
and I ger the error:
When GROUP BY exists, every simple field in projectors must be in GROUP BY.
I have tried several variations of this query without success. Non of my
books show ...