Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
6
Reply
How to show 0 value if there is no record in sql
Vandana Blogs
Apr 15 2017 4:04 AM
419
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
blank value query
Implimenting Hindi phonetic search