.i have a small question on SQL....can u help me plz.......i have a table......named sregister.......in that fields (staffname, deliverydate, vehicle, chassisnumber et.c. I want to get COUNT of records for each staff, current month (as on date) figures and last year same month figures through a single sql query. Please help to solve........."