Join two SPList

QuickTip: Just saw a blog post by Mark Arned who explains how to join two lists based on an ID column. Mark has created a class which generetes a Join and returns you a List in a form of DataTable. The code can be downloaded from here:

http://code.msdn.microsoft.com/ListDataTable

Sahil Malik also shows you how to perform Joins on two SPList and to represent data in a parent/child format. Check here:

http://blah.winsmarts.com/2007-10-Performing_joins_between_SharePoint_lists.aspx