Database view not showing correct records

[Tarun Kumar10]

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]

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)

[Vallabh Baradk2]

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