Looking for the join between Projects and Associated request tickets

I am trying to create a report that groups by project and show all associated tickets ? Do you have a query for this ?