Dear Sir,

When I run following statment, then I have to face following error message
SQL: DISTINCT is invalid

How to use more than one DISTINCT

Please help

select date1,count(sno)as sno,COUNT(distinct(pcode))as pcode,;
count(distinct(vno))as vno,;
SUM(gswt) as gswt,SUM(trwt)as trwt, SUM(ntwt)as ntwt, SUM(cash)as cash;
	from weights;
	where between(date1,f_date1,t_date1);
	order by date1;
	GROUP BY date1;
	into cursor abcd