sum/count problem

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 -

Re: sum/count problem

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 -