---
sourceDocument: Brazil ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/platform-administration

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Joining tables

# Joining tables using database views {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Join tables into a single view and then create a report based on that view.

Use the Database Views module to create a database view that joins
tables to create a pseudo-table that combines data from each table in the view. You can create a
report on this data by adding the database view as a table in a report. Accessing the database
view does not require database access.
1. [Create a database view](https://www.servicenow.com/docs/gfdcltj6ivXKhcS8Xn_plw)  
   Create the database view.
2. [Add a table to the database view](https://www.servicenow.com/docs/lwKncpuPXVQFjrSqK9oFAg)  
   Specify the table to join to the database view.
3. [Example left join in creating a database view](https://www.servicenow.com/docs/iwGqqiBPgugSME0doY~X~Q)  
   This example shows the proper settings when using left-joins to add tables to a database view.
4. [Specify a field to return](https://www.servicenow.com/docs/o7uV6DUFosZ0xuLQsWYHtg)  
   Restrict or specify a field that you want returned by the joined table.
5. [Relabel a column](https://www.servicenow.com/docs/1_nZ97QWb~Ti8FJEu9luAA)  
   Sometimes, two different tables may have fields of the same name that are both important (such as two tables with a sys_updated_on field). For clarity, relabel one of the fields.
6. [Configuring the number of records to return](https://www.servicenow.com/docs/mZvdBPdtEmRSZ_cvUJD0tA)  
   Specify the number of records to return for a database view when the view is used in a script.
7. [Test the database view](https://www.servicenow.com/docs/H7x7dY4GBt8GIyCa9tH0pg)  
   Verify that the database view works correctly.

**Related concepts**   

* [Displaying function results in a database view](https://www.servicenow.com/docs/Sz0gNPjy107GugPRvHdN1g "Enhance the display of a database view by adding a function field to the output to display function results.")
* [Using disjunctions in complex queries](https://www.servicenow.com/docs/72cTQivnysXKdRsX4VpV8A "ServiceNow performs conjunction (AND) statements before disjunction (OR) statements in a query.")  
**Related reference**   

* [Database views in the base system](https://www.servicenow.com/docs/tvJQS3oReyRnnu4P2Q3cYg "Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.")