tables in access
car (carno Primary key ,name ,type ,cost ,qty ,remark )
sales(carno ,noofcars ,date )
1.print the cars which are fast moving cars i.e fastest selling cars.
pl show me query in access to find fastest selling cars.
select * from car where carno=(select carno from sales where sum(num)=(select max(sum(num)) from sales group by carno) group by carno)