Database view error

dgarad · ‎03-28-2024

I have created a database view I got an error.

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

Dr Atul G- LNG · ‎03-28-2024

Hi @dgarad it may be issue with Where clause. @AshishKM any help here.

*************************************************************************************************************
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]

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

AshishKM · ‎03-29-2024

Hi @dgarad ,

Can you switch the where condition and test it.

-Thanks,

AshishKM

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

dgarad · ‎03-31-2024

Hi @AshishKM

I have tried this also.

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

AshishKM · ‎04-01-2024

if you remove the where clause, what's the output.

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

dgarad · ‎04-01-2024

Hi @AshishKM

The same error occurs. When I removed both tables, as per the below screenshot, the error disappeared.

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad