Database view not showing correct records

Tarun Kumar10 · ‎01-08-2024

Hi,

We are creating a database with different 3 scoped custom tables, and they have nothing in common.

We have created left join data base view with sys_id not null, however it shows extra and duplicate records and not the correct set of records.

Can someone help me here.

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

Hi @Tarun Kumar10

Thanks for update, even you log a HI case. If i can still suggest

- Download the data from 2 tables and check manually, what you want to achieve, is any record there or not , which again guide you to correct the where clause.

Hope the spellings are correct in where clause ( Rare case but can be reason)

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

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

Vallabh Baradk2 · ‎01-11-2024

Hi @Tarun Kumar10 ,

If there is nothing common in the tables we can't make the database view . It will show duplicate records only.

Please mark the answer helpful or correct if it works for you.

Regards,

Vallabh