Sharepoint 2010 relational lists

We now have Projected fields, joins and relational integrity between parent and child lists.


http://www.zimmergren.net/archive/2010/01/04/sp-2010-list-joins-amp-spquery-enchancements.aspx


spquery joins