About Database Views

[bonsai]

I'm using a database view.

The database view displays information from two custom tables.
I believe the database view's function is to display only records that meet the same criteria.
Is there a way to display all records from two tables in a single database view?

I've created a custom role for the custom table.
The operating user has requester privileges.

[Rohit Ladda]

Use "Left Join=True" on one of the table. Try changing the order and where clause based on your custom table design.

[bonsai]

I tried it but it only shows one table record.

[Dr Atul G- LNG]

https://www.servicenow.com/community/sysadmin-forum/i-want-to-display-two-table-data-in-one-list/m-p...