Creating a database view

Create a database view to join tables. You can then create a report based on the database view.