Database view table not returning any results
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-04-2024 01:31 AM - edited 01-04-2024 01:31 AM
I've got the following database view where I'm wanting to return a list of software models with certification tasks:
However when I click on Try It, no results appear. I was expecting the following results to appear:
Can somebody explain what I'm doing wrong?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-04-2024 01:58 AM
Let's break this in to chunks, and try
with 2 table and see results are coming then add 3 and check and then 4th and check
only way to trouble shoot.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2024 10:07 AM
Hi there, It is pretty much try - change & try again.
be aware that the order of the tables, has impact. the left join can be also one issue affecting the results.
today I faced that the text in the "where clause" was wrong, there was an "enter" and that is something it doesn´t like at all.
I leave you here the one I was playing with today
hope it helps!