Very frequent at times, there is a requirement to have a view or fetch data from multiple lists as join tables.  But, since SharePoint is not designed as a relational database, this is really tough achieving.  This can be done easily using the SLAM (SharePoint List Association Manager), which makes the SharePoint lists as relational tables and creates the view in no time.

Please refer the slam.codeplex.com for more details.