How to prevent duplicate count value for inner join

When you join two tables and you want to count only the first table, you can use the distinct command.

select a.OrderID, count(distinct a.Id) as Total from tblOrder a 
inner join tblOrderDetail b on a.OrderID = b.OrderID