Think of two tables like Incident and Metrics, once you create a Database view of both the tables joined together it gives you a view of all Incidents with appropriate Metrics, columns of both the Tables for your Reporting usage.

Hence the use of Database view.

There are lot of examples in the ServiceNow Documentations. check the ones shared by Muhammad.

Thanks,

Saji