Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

About Database Views

bonsai
Mega Sage

‎02-16-2026 06:34 AM

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.

0 Helpfuls
  • 438 Views
3 REPLIES 3

Rohit Ladda
Tera Contributor

‎02-16-2026 06:48 AM

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

0 Helpfuls

bonsai
Mega Sage
In response to Rohit Ladda

‎02-16-2026 07:18 AM

I tried it but it only shows one table record.

0 Helpfuls

Dr Atul G- LNG
Tera Patron

‎02-16-2026 07:22 AM

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

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls