Vandana

Vandana

  • 1.1k
  • 589
  • 75.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
Aarti2
Ankit
3
Arpit2
Nikhil
0
Nipun
1
Piyush
2
Shalini Tiwari5
Yogender Baroda0

Answers (6)