DEV Community

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

Posted on • Updated on

How to prevent duplicate count value for inner join

#tsql #query #mssql

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

Top comments (0)

Read next

mbrennan376 profile image

Implementing Distributed Caching with Redis in Azure Functions

Michael Brennan -

mbrennan376 profile image

Harnessing Extension Methods for DI in Clean Architecture with .NET

Michael Brennan -

softwaredeveloping profile image

The Most Important Thing!

FrontEndWebDeveloping -

michalbryxi profile image

OSX Sequoia & Operation not permitted (os error 1)

Michal Bryxí -