Joint Report (like joint query)

Suren

If I have a project and roles in each project.

So, if I have a project details sheet, and project ID to role details sheet.

Each project many have many rows in the role details sheet.

Can we have a way so we can merge the two sheets in the reports so each row displays the columns based on where that column is coming from and the common field between the two sheets? Like joined query?