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

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Joining tables

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

Release version: Zurich  
Updated July 31, 2025  
![](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/Jf3qquzW0PBwOEKqWbkxbw)  
   Create the database view.
2. [Add a table to the database view](https://www.servicenow.com/docs/xwXzqY1r9XaJGAkHRLIlKg)  
   Specify the table to join to the database view.
3. [Example left join in creating a database view](https://www.servicenow.com/docs/wIoDcZumS3GEIC3d3ccHYQ)  
   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/9w1vT1f0o9o492seUH1s7w)  
   Restrict or specify a field that you want returned by the joined table.
5. [Relabel a column](https://www.servicenow.com/docs/6r3HiPnxhocZUG2Q5GAzWg)  
   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/JWPI7SawxrU1vHiHrwO0vQ)  
   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/HH8B11LOCaP6NtNoePZL3w)  
   Verify that the database view works correctly.

**Related concepts**   

* [Displaying function results in a database view](https://www.servicenow.com/docs/nazWzOeI_aDbkgbMECjfUw "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/oOvxhQyTmBVtr4StJOovxQ "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/IbAIhoT1WYVJvMmH4haM6A "Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.")