Using SharePoint Designer, you can create a join between two SharePoint lists, and then use the joined list as a data source for future queries, views and reports.