Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
display related data even if the needed data is 0
Hazel Mahmud
Oct 22 2016 5:29 AM
291
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
what is pivot in sql?
How to get the KPI collection of a specific MeasureGroup?