Counting the product delivery
Posted on 2011-03-10
Hi, I have two tables namely tblProduct and tblDelivery with the following definition:
tblProduct - pid,pdesc
tblDelivery - pid,date,time,location
where the keys are bold.
Now I want to construct a sql statement to display pid,pdesc,totalNumberOfDeliveryBasedOnDate sorted by pid, date
Please advice me on how to construct this sql statement.