DEV Community

Cover image for How to prevent duplicate count value for inner join
Ferhat Karataş
Ferhat Karataş

Posted on

How to prevent duplicate count value for inner join

Using Distinct keyword

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
Enter fullscreen mode Exit fullscreen mode

Discussion (0)