How to join two tables in a database view, when they do not have any common fields?

[aadilk]

Thank you for all your help.

We would like to join two tables ( table A and table B) using the Database view function.

Both table does not have any common fields.
I need to reflect data from both tables in a calendar type report.

If there is any way, no matter how trivial, I would appreciate it if you could let me know.

Thank you in advance.

[Joni V B]

Hi @aadilk ,

It's not really a report, but you could create a workspace with a calendar that uses an EVAM definition to fetch information from different tables in a generic format.

https://www.servicenow.com/docs/bundle/xanadu-servicenow-platform/page/administer/evam/task/define-c...

[Uncle Rob]

Are the tables TASK tables by any chance?
If so you could build the report on base task [task] and then use filter only for Task Type = A or Task Type = B
No DB view required.