<div>
select a.pid, a.desc, count(b.pid), b.date from tblProduct a, tblDelivery &nbsp;b where a.pid = b.pid group by b.date
</div>


select a.pid, a.desc, count(b.pid), b.date from tblProduct a, tblDelivery  b where a.pid = b.pid group by b.date

<div>
<div class="content wysiwyg-content">
Hi, I have two tables namely tblProduct and tblDelivery with the following definition:<br />
<br />
tblProduct - <b>pid</b>,pdesc<br />
tblDelivery - <b>pid,date,time</b>,location<br />
<br />
where the keys are bold.<br />
<br />
Now I want to construct a sql statement to display pid,pdesc,totalNumberOfDel<wbr />iveryBased<wbr />OnDate sorted by pid, date<br />
<br />
Please advice me on how to construct this sql statement.
</div>
</div>


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.

Counting the product delivery

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.