There are two ways come to my mind!
1. SharePoint List Collection is a solution which can do that!
2. This solution Mauro Cardarelli : Aggregating Data From Different SharePoint List Types looks...