Re: Preformance in multiple join

[Felix Geerinckx]

Rasmus Toftegaard Wrote:

> My only problem is that I am not able to count the calls because
> if 3 prices is related to the call the each line appears 3 times and if only 2 then it appears 2 times ....

Maybe you can use

... COUNT(DISTINCT data_id) ...

But there is another problem.
Columns in a SELECT list are indeterminate (read meaningless) unless they
appear in an aggregate function or in the GROUP BY clause.
This is the case for your columns data_id and date.

See 12.10.3. GROUP BY and HAVING with Hidden Fields in the Reference Manual.

--
felix
Please use BBCode to format your messages in this forum.