DEV Community

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

Posted on • Edited 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

okoye_ndidiamaka_5e3b7d30 profile image

Sustainable Web Design: Building Environmentally-Friendly Websites for a Greener Future

Okoye Ndidiamaka -

scrapfly_dev profile image

What is HTTP 401 Error and How to Fix it

Scrapfly -

shinetechsoftwareinc profile image

Best Practices for Agile Development in Distributed Teams

Shinetech Software -

krschap profile image

Working with open imagery of the world ? : OpenAerialMap

Kshitij Raj Sharma -