Re: sum/count problem

2001-01-23 Thread Bob Hall
>Hi, > >I try to use 2 COUNT's and a SUM in query from 2 tables, but am not able >to get the results I want. > >The 2 tables are batches and testresults, and have the following fields >and relation: > > batches: testresults: > - batch_nr <---+ - id > - date | - st

sum/count problem

2001-01-23 Thread Wouter Siteur
Hi, I try to use 2 COUNT's and a SUM in query from 2 tables, but am not able to get the results I want. The 2 tables are batches and testresults, and have the following fields and relation: batches: testresults: - batch_nr <---+ - id - date | - status - siz