Hi,
I ' ve a sql problem and want to resolve it with Firebird 1.5.1.
Follwing select:
select count(distinct id_apos),count(distinct f_id_auftrag),count(distinct
f_id_kunde),sum(f_weight),sum(f_quantity) FROM t_apos ...JOIN...
WHERE ...

My problem is that i have some doubles in id_apos in the select and i want to sum the weight of every apos only one time.
Is this possible with normal sql?

mfg
Carsten



[Non-text portions of this message have been removed]