Hi,
I guess the problem is you missed an AND between the where clauses salesman and mydate.
select item_name,SUM(qty),SUM(total_amt) from invoice where salesman=? mydate BETWEEN ? AND ? GROUP BY item_name"
I guess the below code would work.. let me know..
select item_name,SUM(qty),SUM(total_amt) from invoice where salesman=?
and mydate BETWEEN ? AND ? GROUP BY item_name