Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Vandana
1.6k
548
64.8k
How to show 0 value if there is no record in sql
Apr 15 2017 4:04 AM
hii,
Supposer I have a
Table Volunter
and there are some name
Aarti,
Ankit,
Nipun,
Piyush,
Shalini Tiwari,Yogender Baroda,Nikhil which are in it
have to fetch the count(volunteer) from other table
Tbl_lead
.
If there is record in Tbl_lead then it will show if the name not found in Tbl_lead then it show 0 value. as below table mention. how to does so. with sql query. please help.
Volunteer
Column1
Aarti
2
Ankit
3
Arpit
2
Nikhil
0
Nipun
1
Piyush
2
Shalini Tiwari
5
Yogender Baroda
0
Reply
Answers (
6
)
blank value query
Implimenting Hindi phonetic search