About SQL SERVER LEFT JOIN and Group by
I have two tables,Blog table has a FK BlogTagID column point to BlogTag
table:
Blog table:
BlogID BlogTagID BlogTitle
1 2 test1
2 1 test2
3 2 test3
BlogTag table:
BlogTagID BlogTagName
1 JAVA
2 .NET
3 PHP
I would like to get the result:
BlogTagName count
JAVA 1
.NET 2
PHP 0
How to get this?Thank you very much!
No comments:
Post a Comment