Database view table not returning any results

matthew_hughes · ‎01-04-2024

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?

Dr Atul G- LNG · ‎01-04-2024

Hi @matthew_hughes

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]

****************************************************************************************************************

Ana39 · ‎08-08-2024

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!