I am new to progress 4gl. i have one query where I have to count number of sales order for particular customer. for eg: I have table as so_mstr and so_cust is my customer name field and so_nbr is my sale order number field. in SQL I tried like this , select so_cust,count(distinct so_nbr) from so_mstr group by so_cust. pls help me in progress. Thanks. Continue reading...