How to join multiple tables?

[Yuki21]

How to join multiple tables in ServiceNow?

<Sample SQL>
SELECT
 TABLE_1.AAA,
 TABLE_1.BBB,
 TABLE_2.CCC
FROM FROM
 TABLE_1 INNER JOIN
 TABLE_2 ON
 TABLE_1.DDD = TABLE_2.DDD
WHERE
 TABLE_1.EEE IS NULL

[palanikumar · Accepted solution]

You can use database view. Refer the below URL for more details:

https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/concept/c_DatabaseViews.html

Thank you,

Palani

[Yuki21]

Thank you
By the way, is it possible to combine VIEW and VIEW?

[palanikumar]

You can join database views. You need to add all the tables in both view to join them.

Please close the thread if my answer satisfies your question.

Thank you,

Palani