join is not possible in the list as they are not RDBMS.but through good coding logic, u can achieve it , this will make data access slow , but will work fine,and if u r trying to generate reports than sqlreporting service can help u in joining two lists

If you need to perform joins between SharePoint lists, try WICE JoinPro.WICE JoinPro is a powerful tool that allows you to realize all kind of join (inner, full, left, right) between your lists and apply sorting, filtering, grouping and paging options without using SharePoint Designer.Through its user friendly editor, you will be able to configure your data source defining relations between multiple lists coming from different sites and servers using endless parameters (from 2 to n).JoinPro has a powerful WebPart that can easily display your data in any SharePoint page.Get the trial version and check our website for more details!http://sharepoint.wice-group.com/

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.