---
sourceDocument: Australia ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/platform-administration

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Joining tables

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

Release version: Australia  
Updated March 12, 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://servicenow-prod.fluidtopics.net/6gh4wIGSCGDW~XQxhSyUTw)  
   Create the database view.
2. [Add a table to the database view](https://servicenow-prod.fluidtopics.net/HeHUMLlJPED3IyrC1PbHjw)  
   Specify the table to join to the database view.
3. [Example left join in creating a database view](https://servicenow-prod.fluidtopics.net/poLUQfgpiLh6jFypVj_jNg)  
   This example shows the proper settings when using left-joins to add tables to a database view.
4. [Specify a field to return](https://servicenow-prod.fluidtopics.net/A_TFnLiOeOT~XXZDKhbEKA)  
   Restrict or specify a field that you want returned by the joined table.
5. [Relabel a column](https://servicenow-prod.fluidtopics.net/29scHYwNPA6Huy0u5JorOA)  
   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://servicenow-prod.fluidtopics.net/PU55a8pZWl14YKN3RDY94g)  
   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://servicenow-prod.fluidtopics.net/LJ~HD_oUKtpMjHZp6w7A6g)  
   Verify that the database view works correctly.

**Related concepts**   

* [Displaying function results in a database view](https://servicenow-prod.fluidtopics.net/hH26kDvzeg8wDnW67Y~V1Q "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://servicenow-prod.fluidtopics.net/90uR13646qeBWPFLdDzE4w "ServiceNow performs conjunction (AND) statements before disjunction (OR) statements in a query.")  
**Related reference**   

* [Database views in the base system](https://servicenow-prod.fluidtopics.net/AxZ12NmnVs7o1eBUibuMvA "Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.")