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
For further actions, you may consider blocking this person and/or reporting abuse
Yale Araujo -
mili nakrani -
Mehdi mFat -
Fabio Caccamo -
Once suspended, freakappdev will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, freakappdev will be able to comment and publish posts again.
Once unpublished, all posts by freakappdev will become hidden and only accessible to themselves.
If freakappdev is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Ferhat Karataş.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag freakappdev:
Unflagging freakappdev will restore default visibility to their posts.
Top comments (0)