Hazel Mahmud

Hazel Mahmud

  • NA
  • 299
  • 65.3k

display related data even if the needed data is 0

Oct 22 2016 5:29 AM
hello...
 
 how do i display related data if the data i needed result is 0. 

 
 
i have the above Sql and the result are as shown but sometime there are result that doesn't exist but i want to display 0 at the count7 column with related where condition such as ans_ss_id, ans_term and so on as above result..  how do i do that..please someone help me..tq in advance
 

Answers (2)