hi all,

____________________
select hspectacle.hnum, count(*)

from
hspectacle left outer join v_jprix
on( hspectacle.hnum=v_jprix.hnum )

group by hspectacle.hnum
____________________________

gives
hnum | count(*)
1232 2
1564 8
461 7
....

But i want also the rows with count(*) = 0

How to do it???
thx