How to join three tables using a database view when one of the three tables does not have a common ?

[Yuya2009]

Thank you for all your help.

We would like to join three tables (A table , B table and C table) using the Database View function and export them in csv file format.

Two of the three tables (A table and B table) have common fields and the other table (C table) has no common fields.

Table C contains only fields that will be used after export, and only headers are needed during export.

No values are entered for these fields on the ServiceNow side.

As mentioned above, the C table table does not have any fields with common values, so the join will not work.

The solution I can think of at the moment is to create a field with a common value in the C table, but if there is another better way, no matter how trivial, I would appreciate it if you could let me know.

Thank you in advance.

 

[H_9 · Accepted solution]

Hello,

For union of the tables there must be a common field (foreign key) because that will be used for applying the filter for the union. Hence I think you will need a reference field on the C table without that you wont be able to join them. You are heading in the right direction.